+ Reply to Thread
Results 1 to 4 of 4

Save workbook with new dynamic file name to specific folder.

  1. #1
    Registered User
    Join Date
    03-07-2018
    Location
    Northampton, England
    MS-Off Ver
    MS Office 2016
    Posts
    7

    Save workbook with new dynamic file name to specific folder.

    Afternoon all,

    I am looking to use a macro to save the whole workbook as a new file with a new name that included the date along with to a specific folder name.

    currently i have the bellow that will save a selected cell range.

    Any help appreciated.

    Please Login or Register  to view this content.
    Last edited by Destiny1990; 03-18-2018 at 09:41 AM.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,150

    Re: Save workbook with new dynamic file name to specific folder.

    For example:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-07-2018
    Location
    Northampton, England
    MS-Off Ver
    MS Office 2016
    Posts
    7

    Re: Save workbook with new dynamic file name to specific folder.

    Sorry what I meant was to remove the use of a range and just safe the file with a new name into the file path.

    Not to save a range that is shown.

  4. #4
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,150

    Re: Save workbook with new dynamic file name to specific folder.

    This above was "for example":
    Please Login or Register  to view this content.

+ 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 worksheets as a new workbook in a specific folder
    By Superutz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2015, 09:53 AM
  2. [SOLVED] Save as xlsm file with specific name & specific folder
    By namialus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2015, 03:32 AM
  3. Button to save workbook, with value in specific cell (H5), in a specific folder
    By markeeny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2014, 01:15 PM
  4. VBA to save a same workbook with different name in specific folder
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2014, 11:42 PM
  5. [SOLVED] macro to save file to specific folder with file name from cell reference
    By mezza89 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2013, 11:32 AM
  6. [SOLVED] Macro to save workbook to specific folder with a specific name, then kill/disable itself.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2012, 03:50 PM
  7. [SOLVED] How to save file to a specific folder?
    By rko281 in forum Excel General
    Replies: 5
    Last Post: 02-03-2005, 10:30 AM

Tags for this Thread

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