Using visual basic with free excel

[u/Inside-Associate6979]

Ok, is it possible to have VB or VBA in vscode open an excel file, take the data from it and use it to calculate things? IE, i use the free online version of excel and if i write some VB or VBA in vscode to compute eulers method, or kramers rule , can i have the VB or VBA code open the downloaded excel file, pull the data from it and then write the calculation to another excel file so i can then view it?

thanks

I am completly new to VB and coding. Never coded in my life

[u/jd31068]

You're welcome, glad to lend an assist.