Thread: Get the name of all workbooks open from access
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Xav[_2_] Xav[_2_] is offline
external usenet poster
  
Posts: 4
Default Get the name of all workbooks open from access
This code works from and to the current Excel instance.
The fact is if I have more than one instance of Excel open I don't know
how to access those instances. I suppose the answer might be to use
GetObject? But does anybody know how to look up all the Excel instance.

Reply With QuoteReply With Quote