validate a directory or file exits

Posted to microsoft.public.excel.programming

Simon Shaw[_5_] Simon Shaw[_5_] is offline

external usenet poster

Posts: 17

validate a directory or file exits

How do I validate if a file exists without using On Error Resume Next then
trying to open it?

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 can I validate my Excel password against a INI file	Andrea	Excel Worksheet Functions	1	June 30th 09 09:10 PM
file save error: the file or directory cannot be created	dublg	Excel Discussion (Misc queries)	1	September 25th 06 07:07 PM
Excel should let me sort the file directory when saving a file	Beanee70	Excel Discussion (Misc queries)	0	March 14th 06 07:03 AM
Excel Exits on File Close with Outlook	Erin Searfoss	Excel Discussion (Misc queries)	1	January 16th 05 09:43 PM
get path - save new file - same sub-directory as existing file	tegger	Excel Programming	2	October 21st 03 10:45 AM

All times are GMT +1. The time now is 10:05 AM.

About Us