Request Directory From User - VBA Code

[wkbailey2]

I am trying to find the VBA code to prompt the user for the directory
to save a file. The code will define the files name, I just need the
user to direct the program to the folder which the user would like the
file saved in. I have been searching all over the internet but cannot
find the write answer. Please help.

 

[Bob Phillips]

Since XL2002 there is a browse dialog.
With Application.FileDialog(msoFileDialogFolderPicker)
.Show


MsgBox .SelectedItems(1)


End With


Look up FileDialog in the VBA help


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[NickHK]

If you need to support versions prior to XL2002, use the BrowseForFolder
API.
http://www.cpearson.com/excel/BrowseFolder.htm

NickHK