You know, actually this will be great.

Thanks JLGWhiz.

Have a great day.

Brad

"JLGWhiz" wrote:

fileName = Application.GetSaveAsFileName

will call the dialog box then

ActiveWorkbook.SaveAs Filename:=fileName

Puts it away.

"Brad" wrote:

Thanks for taking the time to read my question.

I am running a macro to send data to a text file using Print # Statement.

I want the user to be able to run the macro, and have a window pop up that
lets them select the location they want to save the file to. It should look
just like windows explorer. I can do this in Access but not sure how to
accomplish in Excel. I did it a long time ago, and can't find my file that
had it.

Thanks,

Brad