Request Directory From User - VBA Code

[WB]

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.

Will

 

[Bob Greenblatt]

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.

Will

Look in vba help for getsaveasfilename. It explains the function and has an
example. Ask if you need more help.