Posted to microsoft.public.excel.programming

Alberto Ast[_2_] Alberto Ast[_2_] is offline

external usenet poster

Posts: 181

Open file validation

I am opening a file with macros but some times the file is open by other
users and then my macro fails... how can I avoid the macro to fail if the
file is open?

I do not want it to ask me if I want to open as ready only... I would like
to be able by program to know I could not open it and then procedd to do
something else.

What do I need to do?
Thanks.

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
open file validation	Alberto Ast[_2_]	Excel Programming	2	October 26th 09 04:38 AM
In Excel - Use Windows Explorer instead of File Open to open file	KymY	Excel Discussion (Misc queries)	1	August 5th 06 09:59 PM
Open a file do a macro ( made) and open next succesive file	SVTman74	Excel Programming	5	April 21st 06 10:14 PM
Open File or Switch Between Windows if File is Open	Ricky Pang	Excel Programming	2	July 8th 05 05:51 AM
Open File or Switch Between Windows if File is Open	Ricky Pang	Excel Programming	0	July 2nd 05 08:41 PM

All times are GMT +1. The time now is 06:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us