Thread: Auto Save
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael McGarrity Michael McGarrity is offline
external usenet poster
 
Posts: 1
Default Auto Save

Hi, I'm really new to VBA or complex Macros. I am looking for a macro
that would run automatically daily at 2am, save as
CorporateActionSummary MM.DD.YYY.xlsx (current date). Essentially I
would like a new worksheet saved and ready for me when I get in at 6am
with all of yesterdays data, I do not want to overwrite the original
sheet.