Thread: How do I use a macro to save to a specific drive in Excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Meredith Meredith is offline
external usenet poster
  
Posts: 15
Default How do I use a macro to save to a specific drive in Excel?
I wrote a macro in excel to facilitate creating monthly reports. I want it
to save to a new folder each month (ie. the current monthly folder), but I am
not sure how to write a changing "save as" formula.
Reply With QuoteReply With Quote