+ Reply to Thread
Results 1 to 7 of 7

save as with current filename plus cell reference text

  1. #1
    Registered User
    Join Date
    11-07-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    51

    save as with current filename plus cell reference text

    I need to save the file as a new name.
    The first part of the filename is a customer's name and the second part of it is my file # reference.
    It looks like this:

    CUSTOMER NAME 1234

    I need it to keep the "CUSTOMER NAME" and change the file number at the end (will always be 4 digits).

    The file number is always in N3. but the customer name moves from cell to cell based on the document (sheets) within the workbook.

    Thank you for your help!

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: save as with current filename plus cell reference text

    If "CUSTOMER NAME 1234" is in cell A5 and the file number in cell N3, this will get the new file name.
    Please Login or Register  to view this content.
    Need more information to be more accurate

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: save as with current filename plus cell reference text

    Hi,

    I assume you know how to do the saving part, and just need help with creating the new filename...?
    Try:
    Please Login or Register  to view this content.
    You can then use the variable in your save code. That is assuming the workbook already starts off being the customer name but a different file number of course.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: save as with current filename plus cell reference text

    The first part of the filename is a customer's name
    Did not read this properly.
    Arkadi has it sussed.

  5. #5
    Registered User
    Join Date
    11-07-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: save as with current filename plus cell reference text

    This is the code I am currently running, (with your help!) and it is saving as the current CUSTOMER NAME 1234 plus the new file number so it ends up looking like this CUSOTMER NAME 12349876.
    Please let me know where I have errors. thanks!

    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: save as with current filename plus cell reference text

    Try this instead.

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    11-07-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: save as with current filename plus cell reference text

    That fixed it.

+ 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. Edit filename in Formula with reference to a cell in current file
    By yatin1964 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2013, 09:35 AM
  2. Save as CSV to specific folder on desktop and current date as filename
    By stokiejames09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2013, 05:52 PM
  3. [SOLVED] "Save As" in current directory, filename from cell value
    By AlexCoyne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2012, 08:33 PM
  4. Replies: 2
    Last Post: 06-19-2012, 12:48 PM
  5. VBA script- save file with current filename
    By -James_ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-06-2012, 04:10 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