Hello! I want to write code for connect VBA for Excel script. How I make this? Thank You!

Answer 1

VBA is embedded into MS applications, so what exactly do you want to do? Write a code in a different language which would inject instructions into VBA environment in Excel or..?

Answer 2

If just for reading, you may use pandas read_excel() method. Works like a charm, really (as everything in pandas :)

For xls data manipulation (also saving an .xls) openpyxl might do the trick.

Answer 3

http://www.excel-easy.com/vba.html
http://goalkicker.com/ExcelVBABook/
http://goalkicker.com/VBABook/

Answer 4

Don't understand your question. Connect to Excel or connect from Excel? Also, what are you connecting to?

Answer 5

Duncan, connect to Excel, import tables as array to python script

Answer 6

Ok, I haven't been that adventurous just yet, so can't help with this one sorry.