Thread: MACRO to save current worksheet with variable filename
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wes_A[_2_] Wes_A[_2_] is offline
external usenet poster
  
Posts: 37
Default MACRO to save current worksheet with variable filename
I need to save the currently active sheet as a new workbook in a different
directory (folder). The filename is volatile and is contained in a cell on
the currently open sheet.
e.g. September, October ....
The saved file needs to be an Excel workbook format *.xls or *.xlsb
I am trying to write a MACRO to automate this file save and then retuirn to
the currently open sheet.
Can anyone help?
Reply With QuoteReply With Quote