Forum Discussion

divernut's avatar
divernut
Occasional Contributor
14 years ago

Using the COM for opening Excel, can't select a particular sheet.

I am using the COM to work with Excel 2007. When I use the following code, it opens to the first sheet by default.  Excel = Sys.OleObject("Excel.Application");   Delay (3000); // Wait until Exce...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
14 years ago
Do you need to have Excel open and visible or are you just trying to read/write from it?



I think you can call a "sheets" property off the "book" object that is returned from the Open command.  Then you indicate "book.Sheets(SheetName)" to return the specific sheet you want.



Don't know if this helps.