+ Reply to Thread
Results 1 to 3 of 3

Save as workbook with date and time in filename

  1. 07-13-2013, 03:56 PM #1
    Undeveloped
    Undeveloped is offline
    Registered User
    Join Date
    06-13-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2010
    Posts
    1

    Save as workbook with date and time in filename

    I am trying to use a macro enabled template to document work orders. I want to enter order data into the template and save as a workbook with the date and time in the file name. I have been searching forum after forum and I haven't found a method that works.

    Thanks

    -JT-
    Reply With QuoteRegister To Reply
  2. 07-13-2013, 04:05 PM #2
    amar05
    amar05 is offline
    Registered User
    Join Date
    08-30-2012
    Location
    Ottawa
    MS-Off Ver
    Excel 2007
    Posts
    59

    Re: Save as workbook with date and time in filename

    Something like that?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 07-13-2013, 05:08 PM #3
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Save as workbook with date and time in filename

    Hi, Undeveloped,

    Please Login or Register  to view this content.
    which would save to the default save location in Excel or
    Please Login or Register  to view this content.
    which should save on the temp folder on the local hard drive.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro save with referenced filename and time
    By rockhunter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2011, 05:36 PM
  2. [SOLVED] Save Filename With Date In It
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 05-20-2011, 08:08 AM
  3. macro to save sheet from workbook. Specified location and filename
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2011, 11:47 PM
  4. Save xls with date appended to end of filename
    By mattmac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2008, 06:41 AM
  5. Save Workbook as Current Date/Time
    By Jacob_F_Roecker in forum Excel General
    Replies: 1
    Last Post: 10-25-2005, 05:05 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1