Check if spreadsheet is open

[wandan]

Hello,

I am using MS Access 2010. I have links to several password protected Excel 2010 files. In order to access the file, it has to be open. So, I added a call shell to open the file. I need to be able to check to see if the file is already open before running the Call Shell. Can anyone tell me how to do that? Or any other suggestions for using links to password protected files?

Thanks!

 

[MazeWorX]

Try:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=625

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[PHV]

Have a look here:

http://vbaadventures.blogspot.com/2008/08/isfileopen.html

http://www.vbaexpress.com/kb/getarticle.php?kb_id=468

http://www.cpearson.com/excel/ISFILEOPEN.ASPX

...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886