Posted to microsoft.public.excel.programming

mcphc

external usenet poster

Posts: 44

Check if file on intranet exists

I need to check if a file with path "http://pmnet/113-FR-001.xls" exists
without opening it. I've tried using Dir(myPath) but I get an error 52 'Bad
file name or number'. I've also tried using the FileExists method in VB but
I'm not sure how to use it.

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
Check if a File Exists	Ray Clark[_2_]	Excel Programming	4	June 11th 08 05:13 PM
Check if file exists	Jon	Excel Discussion (Misc queries)	14	October 4th 07 04:57 PM
How to check if a file exists in an ftp folder	LL Cool A	Excel Discussion (Misc queries)	3	May 16th 06 09:22 PM
check if file exists	Curt	Excel Programming	0	December 7th 05 05:02 PM
check if a file exists / is open	Mark Kubicki	Excel Programming	1	December 4th 03 05:56 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us