Posted to microsoft.public.excel.programming

Todd Huttenstine[_2_] Todd Huttenstine[_2_] is offline

external usenet poster

Posts: 237

File Not found

Worksheets(4).Range("A6").Value contains a file path.

What is the code to look for a file in that
location "Worksheets(4).Range("A6").Value" and if the file
is NOT FOUND, then msgbox "File Not Found" else continue
with code?

Todd Huttenstine

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
File not found	Eric	Excel Discussion (Misc queries)	3	February 27th 08 08:40 PM
File Not Found menu pops up after I open a file	Harveytunes	Excel Discussion (Misc queries)	3	January 27th 06 07:23 PM
File not found	Ed	Excel Discussion (Misc queries)	2	September 20th 05 08:45 PM
How do I reference external data from a file, file name found in .	Clux	Excel Discussion (Misc queries)	1	February 10th 05 10:52 PM
'File not found'	Hank Scorpio	Excel Programming	0	July 29th 03 10:45 AM

All times are GMT +1. The time now is 07:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us