+ Reply to Thread
Results 1 to 1 of 1

Save file with specific name

  1. #1
    Registered User
    Join Date
    08-14-2017
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    48

    Save file with specific name

    Good day everybody,

    I had a working code from a similar file I copied, but is not working anymore (for some odd reason).

    Situation:
    I want to automatically save the file in a specific folder with the name DASHMA-GAP + the content from a specific cell in that workbook.
    The content of that cell is a date =(not the date of today, just random. Code I use is the next one;

    Dim strFilenName1 As String
    Dim FName As String
    FName = Sheets("INFO").Range("D28").Text

    strFilenName1 = "X:\Management-Operations-Supply Chain\Supply Chain Management\SC Proces & Projectmgmt\AUTOMATIC ORDERING\2. DASHBOARDS AND ANALYSE\2.5 DASHBOARD AUTOMATIC\02 GAP\01 MAKRO\02 DASHBOARD RESULTS\DASHMA-GAP " & FName & ".xlsx"
    ActiveWorkbook.SaveAs Filename:=strFilenName1, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False


    If I run this, I get no error and he saves the file WITHOUT the content of cell D28 at the tab INFO.

    Could it be the reason that the file is hidden?


    Thanks alot!
    Another working code to replace this one is fine as well!
    Last edited by BramGrey; 04-04-2019 at 08:36 AM.

+ 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. [SOLVED] How to Save as a file with current date and specific text as file name
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2018, 12:30 AM
  2. Save specific sheet as CSV file prompting for a file name
    By Onleme in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2018, 09:17 PM
  3. [SOLVED] Save selected print area as a pdf file using the text from a specific cells as the file na
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2015, 04:14 PM
  4. [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
  5. [SOLVED] Macro to manually choose PDF file and save it to a specific location with specific name
    By tnuis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2014, 07:47 AM
  6. Replies: 0
    Last Post: 07-11-2013, 02:08 AM
  7. [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

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