Results 1 to 4 of 4

Thread: Date References to save files using VBA Code

  1. #1
    Member mrmmickle1's Avatar
    Join Date
    Sep 2012
    Posts
    51
    Rep Power
    12

    Date References to save files using VBA Code

    Is there an easy way to save a file with todays date?

    For Example Customer Service Report "&Date&" or something to that effect "Today()" but in code where it would make the file unique?
    Using Excel 2010

  2. #2
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    12
    Code:
    Sub M_snb()
      thisworkbook.saveas "G:\OF\voorbeeld_" & format(date,"ddmmyyyy") & ".xlsx",51
    End Sub

  3. #3
    Member mrmmickle1's Avatar
    Join Date
    Sep 2012
    Posts
    51
    Rep Power
    12
    snb,

    Thank you again! I am learning slowly but surely. I appreciate the help.

    The 51 specifies .xlsx format correct?

    -Matt
    Using Excel 2010

  4. #4
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    12
    Yes, you do !

    Ckeck that in the VBEditor's help files, lemma saveas / fileformat

Similar Threads

  1. Replies: 5
    Last Post: 06-15-2013, 12:40 PM
  2. HOW TO Save Processed Files Into Different Folders
    By DARSHANKmandya in forum Outlook Help
    Replies: 6
    Last Post: 04-10-2013, 07:29 PM
  3. Save Processed Files Into Different Another Folder
    By DARSHANKmandya in forum Excel Help
    Replies: 1
    Last Post: 03-22-2013, 07:10 PM
  4. Replies: 17
    Last Post: 12-18-2012, 04:15 PM
  5. Save Chart As A Picture VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 05-14-2011, 04:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •