08-02-2005 01:26 PM
08-02-2005 03:12 PM
If you are starting with the example Write Table to XL, just change the Workbooks->Add to Workbooks->Open. Then change the Sheets->Add to Sheets->Item. The variant that is returned needs to be converted to a Worksheet type just like in the example. The Index input is a variant and can accept either an integer sheet index or a string sheet name.
If you are expecting the specified sheet to be displayed by the ActiveX Item method, you won't see it. The reference allows direct read/write of sheet contents without it being visible. If you need to see it, use the Worksheet->Activate method.
08-06-2009 11:49 AM
I have a few problems with the examples when I try to open XL, it opens continuously and never stops how can i make that excel only open one time ? Because when I run the other examples, I have the same problem it is always opening new windows so I can't work with 'em
08-06-2009 01:17 PM
08-10-2009 11:31 AM