Thread: Workbooks collection is empty even though the some of the document is open
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Vic Eldridge[_3_] Vic Eldridge[_3_] is offline
external usenet poster
  
Posts: 112
Default Workbooks collection is empty even though the some of the docu

Do you have any idea how to workaround this condition? May be by
getting all the instances?. I know getobject will return the first
instance it returns.

I'm not sure if C#'s GetActiveObject and VB's GetObject are the same beast,
but it certainly sounds like they are (warts and all !). If so, the
following thread discusses a way to return a specific instance.

http://groups.google.com.au/group/mi...db4ab107e4a7e/


Regards,
Vic Eldridge
Reply With QuoteReply With Quote