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.
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
Yes, I was doing that. But when i will make the executable, Will I have the same problem? I think it will run as if I clicked on "Run Continously" right?