4 Replies Latest reply: Jun 13, 2014 4:10 AM by Kevin Rovers RSS

    How to save excel file with current date using macro

      Hi all,

       

      I have a sheet with 2 objects.

      These objects are sent to an existing Excel document using macro. (Found on this community)

      Then is saves the file (overwrite)

       

      I need to save the file with a sort of timestamp in it's document name.

       

      Who can help me?

       

      I need to save the file like this:

       

         ' Save and quit  
         objExcelSheet.SaveAs "C:\documenten\test\test20140612.xlsx"
         objExcelApp.Application.Quit  
         SET objExcelSheet = NOTHING        
         SET objExcelApp = NOTHING  
      

       

      But then with a variable date / date function.

       

       

      Thanks,

      Kevin