KeriM

Member

Posts: 70

Quote:

Originally Posted by Ben McClave

Keri,

Have you tried this?

With Application.FileDialog(msoFileDialogFolderPicker)
.InitialFileName = "C:\Desktop"
.Show
End With

Thank you! That worked perfectly!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Find file in folder and sub-folder and sub-folder and sub-folderand etc...	Charlotte E.[_3_]	Excel Programming	1	September 15th 12 12:21 PM
Open Folder dialog box	Brad	Excel Programming	4	February 8th 11 02:03 AM
Check for file in folder, if not there, open folder to rename file	Don M.	Excel Programming	9	October 22nd 08 07:34 PM
Save file in a new folder, but create folder only if folder doesn't already exist?	nbaj2k[_40_]	Excel Programming	6	August 11th 06 08:41 PM
open file from folder save in new folder	tim64[_3_]	Excel Programming	20	June 17th 05 07:58 PM

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

About Us

"It's about Microsoft Excel"