+ Reply to Thread
Results 1 to 7 of 7

Save-As name based on cell value

  1. #1
    Registered User
    Join Date
    07-01-2010
    Location
    adelaide
    MS-Off Ver
    Excel 2003
    Posts
    86

    Save-As name based on cell value

    Can someone please help

    I am looking for a code that will:

    1) Bring up save-as popup
    2) Worksheet to be saved as name in cell (A1)
    and either
    path to be chosen (preferable)
    or
    to desktop.

    thanks in advance

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

    Re: Save-As name based on cell value

    Try
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-01-2010
    Location
    adelaide
    MS-Off Ver
    Excel 2003
    Posts
    86

    Re: Save-As name based on cell value

    i have tried this and it doesn't work
    it shows only the option for folder name and no where to name the filef and when you try to save it goes has pop up of method 'save as' of object_'workbook' failed

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

    Re: Save-As name based on cell value

    Did you select the folder where the file should be saved in and click on OK at the bottom?
    When I tried it here it saved the workbook in the folder I selected in the pop-up with the saved file name as in cell A1 and an .xlsm extension.
    That is what I understand you wish from Post #1 to be. If it is not, please explain further.

  5. #5
    Registered User
    Join Date
    07-01-2010
    Location
    adelaide
    MS-Off Ver
    Excel 2003
    Posts
    86

    Re: Save-As name based on cell value

    when I select location eg: desktop and then save, it shows the error message.

    i have a code that i use for save to pdf see code.

    which is perfect but instead of save to pdf i just want to worksheet saved.

    Please Login or Register  to view this content.

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

    Re: Save-As name based on cell value

    My bad. I read your first post to save current workbook instead of active sheet. My apologies.
    Save sheet as PDF to desktop.
    Please Login or Register  to view this content.
    Save sheet as xlsm file to desktop.
    Please Login or Register  to view this content.
    Save sheet as xlsm file in selected folder.
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    07-01-2010
    Location
    adelaide
    MS-Off Ver
    Excel 2003
    Posts
    86

    Re: Save-As name based on cell value

    Love it.... Perfect!!!!

+ 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. Replies: 7
    Last Post: 10-14-2019, 02:18 AM
  2. Save location based on another cell
    By Throughstream in forum Excel General
    Replies: 3
    Last Post: 09-20-2018, 05:34 PM
  3. Replies: 1
    Last Post: 04-29-2016, 11:55 AM
  4. VBA To Create Folder Based on Cell Value and Save File as Same Cell Value...HELP!
    By danlynnsydr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2016, 06:58 PM
  5. [SOLVED] Save as pdf based on cell value
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2014, 04:30 AM
  6. Replies: 5
    Last Post: 09-13-2012, 09:49 AM
  7. Replies: 1
    Last Post: 09-12-2012, 11:29 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