Posted to microsoft.public.excel.programming

Dan R.

external usenet poster

Posts: 220

Prompt user to select directory

I'm using this to open a wb on a shared network drive: Set wb =
Workbooks.Open("N:\CP H6 Lookup.xls"). But if for some reason the user
has this drive mapped on O: it's obviously going to error out b/c it
can't find the file, so what can I add to this so that if it does
error out it will prompt the user to select the appropriate directory
containing this file?

Thanks,
-- Dan

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
Prompt user to select a printer using a checkbox within a user	Tom Ogilvy	Excel Programming	0	January 10th 07 03:57 AM
how do I prompt the user to select a cell?	[email protected]	Excel Programming	1	December 19th 06 11:42 PM
prompt user to specify a directory	mini	Excel Programming	5	April 20th 06 06:05 AM
Prompt user to select file with default file selected dialog	Bruce Cooley	Excel Programming	0	September 15th 03 06:43 AM
Prompt user to select file with default file selected dialog	Bob Phillips[_5_]	Excel Programming	0	September 14th 03 09:22 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us