View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 846
Default 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