How to get an object reference to an ALREADY open excel spreadshee
I need to manipulate an already open excel spreadsheet using VBScript. My
problem is that I can't seem to be able to get an object reference to excel
if it's open already. I was able to open an excel workbook and add a sheet,
but I wasn't able to connect to a spreadsheet it if it was already open.
Anybody knows how to do it in VBScript?
E.g: manually open MS Excel and type something in Sheet1. Then when you'd
run this VBScript that I need, it would connect to Sheet1 and would display
the content of it in a message box.
Thanks a lot!
JP
|