Posted to microsoft.public.excel.programming

C[_4_]

external usenet poster

Posts: 5

check if a file is open

Hi

bit of a beginner in excel VBA but i am trying to find out if can check to
see if a file is open

as in

IF 'file a is open' THEN
Code
code
code
ELSE
msg "file a is not open please try again"
END IF

is this possible and does anyone have any code for this

Thanks
C

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to check for Open File!	Ayo	Excel Discussion (Misc queries)	2	August 11th 08 06:55 PM
check if file is already open	mohavv	Excel Discussion (Misc queries)	1	October 15th 07 12:08 AM
File Open Check	dthmtlgod	Excel Programming	1	January 13th 06 02:51 PM
check if file already is open	Mats Nilsson	Excel Programming	2	September 12th 05 09:30 AM
How to check Excel file already Open	Rudy S	Excel Programming	2	January 25th 05 02:00 PM

All times are GMT +1. The time now is 01:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us