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"
         SET objExcelSheet = NOTHING        
         SET objExcelApp = NOTHING  


      But then with a variable date / date function.