Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Word with embedded Excel object which has reference to addin | Excel Discussion (Misc queries) | |||
excel 2000 object reference anywhere? | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
Excel Object Library Reference | Excel Programming | |||
Workbooks.Open(filename) : Returning err: Object reference not... (in VB.NET) | Excel Programming |