Chack if file is open

CPGUY33

New Member
Joined
Sep 27, 2006
Messages
9
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?
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,916
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top