Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
multiple Excel - GetObject - FindWindowA
Name:
Mike
Email (spam proof):
Email the originator of this post
Date:
Tuesday, February 14, 2006
Hits:
71
Discussion (Terms and Conditions):
I have multiple instances of Excel open (not opened by my VB program) I can read/write to the first one open by using Set oExcel = GetObject(, "Excel.Application") I need to set other excel objects similar to :- Set oExcel2 = ..... the next excel application.. Set oExcel3 = ..... the next excel application.. Using API calls I have examples for closing all Excel applications and finding a particular Excel application and closing it. However I cannot find a way of setting multiple Excels to my Excel objects. Regards mike

Sponsored by the best FTP application on the internet: