User select Save To Folder
 

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

User select Save To Folder
 

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

User select Save To Folder
 

Thanks for the reply

Right idea, but I don't want to save my excel sheet, I want the user to
select the destination of the file and then save that path to my code.

So my code starts, then the user will get asked where they want to save the
export file to. I'll assign that result to my code.

So I'll get C:\My Documents\TestFolder\

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

User select Save To Folder
 

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

User select Save To Folder
 

Brad,

See http://www.cpearson.com/excel/BrowseFolder.htm

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Brad" wrote in message
...
Thanks for the reply

Right idea, but I don't want to save my excel sheet, I want the user to
select the destination of the file and then save that path to my code.

So my code starts, then the user will get asked where they want to save
the
export file to. I'll assign that result to my code.

So I'll get C:\My Documents\TestFolder\

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