Chack if file is open

[CPGUY33]

I wrote a macro that will open workbooks that are linked to a main workbook when you open it. The problem is that if you have the linked workbook open it gives you a warning that the file is already open. Is there a way to check if the file is open prior to opening it, checking if it is read-only?

 

[erik.van.geit]

Hi,

you might check out
NIMROD's post in http://www.mrexcel.com/board2/viewtopic.php?t=67223

or http://www.mrexcel.com/board2/viewtopic.php?t=92097

kind regards,
Eirk