View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jknapp1005 jknapp1005 is offline
external usenet poster
 
Posts: 25
Default Saving a text file macro

I have to save files as text files quite often, always to the same place. I
want to be able to run a macro because the folder where these are kept is
buried, to help with security. My problem is it seems like the file has to be
named and saved as something and to somewhere before you can begin running
the macro to save it, which kind of defeats the purpose. How can I write a
macro which will allow me to save a text file, named a different name each
time, and save it to a file?