+ Reply to Thread
Results 1 to 8 of 8

Save a the same workbook but add a variable number at the end

Hybrid View

swade730 Save a the same workbook but... 09-14-2015, 02:44 PM
rkey Re: Save a the same workbook... 09-14-2015, 03:03 PM
swade730 Re: Save a the same workbook... 09-14-2015, 04:31 PM
JOHN H. DAVIS Re: Save a the same workbook... 09-14-2015, 03:29 PM
swade730 Re: Save a the same workbook... 09-14-2015, 04:26 PM
JOHN H. DAVIS Re: Save a the same workbook... 09-15-2015, 06:20 AM
swade730 Re: Save a the same workbook... 09-15-2015, 09:33 AM
skywriter Re: Save a the same workbook... 09-14-2015, 04:09 PM
  1. #1
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: Save a the same workbook but add a variable number at the end

    Hi Swade,

    I usually append this to my filename:
     Format(Now(), "yyyymmdd_hhmmss")
    Does that suit your needs?
    Regards,
    Rick

  2. #2
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Save a the same workbook but add a variable number at the end

    Quote Originally Posted by rkey View Post
    Hi Swade,

    I usually append this to my filename:
     Format(Now(), "yyyymmdd_hhmmss")
    Where would I insert this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Save workbook as variable/pass argument to another module
    By crossfitciaran in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-06-2015, 07:40 PM
  2. [SOLVED] Calculate average of variable number of cells variable number of times
    By WeirnetherlandsBart in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2014, 10:11 AM
  3. [SOLVED] Multiple workbooks into one workbook - asked to save or not save each workbook step remove
    By Benji Jeff in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-20-2014, 09:54 PM
  4. Macro for copying & inserting a variable number of rows into a separate workbook
    By Gunther Maplethorpe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-01-2013, 06:26 PM
  5. [SOLVED] VBA extract X number of rows and save as new workbook
    By freud1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2012, 07:21 AM
  6. Save workbook using variable for save as and for a new folder name
    By TheNewGuy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2009, 10:53 AM
  7. Save average() of a variable selection to a variable
    By ebahr in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-10-2008, 07:15 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1