Posted to microsoft.public.excel.programming

Quietman

external usenet poster

Posts: 109

Determining if a file is open using VBA

I working with several files, I write macros to open them, but I don't want
the macro to run if the file is already open, what command can I use to check
for this

Working in Excel
--
Helping Is always a good thing

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
In Excel - Use Windows Explorer instead of File Open to open file	KymY	Excel Discussion (Misc queries)	1	August 5th 06 09:59 PM
Determining Whether File Exists	Magnivy	Excel Programming	9	June 8th 06 04:51 AM
Open a file do a macro ( made) and open next succesive file	SVTman74	Excel Programming	5	April 21st 06 10:14 PM
Determining File Size	davidm	Excel Programming	3	October 19th 05 07:34 AM
Determining if Other Workbooks Are Open	Chaplain Doug	Excel Programming	6	May 16th 05 08:12 PM

All times are GMT +1. The time now is 07:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us