Posted to microsoft.public.excel.programming

Valeria[_2_] Valeria[_2_] is offline

external usenet poster

Posts: 24

specify an input directory with GetOpenFilename

It works wonderfully!
Thanks a lot!
Valeria

-----Original Message-----
Give this a shot

'Load the Input Dir
InputDirectory = "C:\"

'Save the current Dir for later Clean up
CurrentDirectory = CurDir

'Change the Dir to look in
ChDir (InputDirectory)

'Load FileNameToOpen
FileNameToOpen = Application.GetOpenFilename

'Clean up
ChDir (CurrentDirectory)

HTH
-Merk

.

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
Validation of input against the active directory	Sing Chung[_2_]	Excel Worksheet Functions	1	July 23rd 09 04:19 PM
GetOpenFilename w/default starting directory	[email protected]	Excel Programming	1	November 9th 03 04:55 PM
GetOpenFilename	Hasan Cansü	Excel Programming	0	September 24th 03 01:32 PM
Setting default directory prior to GetOpenFilename	David R[_3_]	Excel Programming	2	September 2nd 03 12:35 PM
Using GetOpenFilename	Robin Seaby	Excel Programming	2	August 6th 03 04:50 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us