Request Directory From User - VBA Code

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.

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)

<[email protected]> wrote in message
news:[email protected]...
> 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.
>

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

NickHK

<[email protected]> wrote in message
news:[email protected]...
> 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.
>