Posted to microsoft.public.excel.programming

Tim Williams Tim Williams is offline

external usenet poster

Posts: 1,588

Application.GetOpenFilename

Dim s
ChDir "C:\Folder\folder2\folder you want"
s = Application.GetOpenFilename

tim

"Greg" wrote in message
...
How do I get this code to look in a certain directory

Application.GetOpenFilename

Directory name

ward5

Thanksin advance

Greg

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
GetOpenFilename	Jenny	Excel Programming	2	October 22nd 04 01:38 PM
How do I set a default path when using Application.GetOpenFilename	pkohler[_8_]	Excel Programming	2	July 13th 04 10:12 PM
How do I set a default path when using Application.GetOpenFilename	pkohler[_7_]	Excel Programming	2	July 13th 04 07:17 PM
Application.GetOpenFilename	Philipp Oberleitner[_2_]	Excel Programming	2	July 9th 04 07:29 PM
Application.GetOpenFileName	ptrowe	Excel Programming	2	September 11th 03 12:54 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us