Detecting if Excel Workbook is already open

[RzB]

I have an Access db that opens an Excel .wks file
and dumps some data to it. I want to be able to
detect if the .wks file is already open. I have found
a number of older posts that have suggested ways
to do this but I don't seem to be able to get any of
them working. I'm using Access/Excel 2002.
Is there a simple way of doing this?
Many thanks,
Roy

 

[Douglas J. Steele]

First, find out whether Excel is open at all. If it is, loop through the
Workbooks collection of the Excel application, checking to see whether or
not your wks file is there.

 

[TC]

He'll have troubles, though if he uses GetObject (which I assume is what you
have in mind), & there are several copies running.

TC

 

[Douglas J. Steele]

Actually, I was thinking along the lines of finding each instance of Excel,
although I see I forgot to mention that detail! <g>

Roy: Take a look in the API section of "The Access Web" for code to
enumerate all running applications.
http://www.mvps.org/access/api/api0013.htm is the specific code, but you
might also find http://www.mvps.org/access/api/api0007.htm to be useful.

 

[RzB]

TC,Douglas,

I'll look at the sites you suggets. I was
hoping for a solution that did not drive
me down the API road.

Anyway - many thanks for your help.

Roy