+ Reply to Thread
Results 1 to 3 of 3

button to save as new work sheet

  1. #1
    Registered User
    Join Date
    03-23-2015
    Location
    Swansea, Wales
    MS-Off Ver
    2014
    Posts
    19

    button to save as new work sheet

    how to If the button is clicked by the user, then the active sheet should be saved as a new workbook with the naming convention: SheetName_(CustomerNo_DD.MM.YYYY) ?

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: button to save as new work sheet

    this is basically what you should do. You just have to change the folder path and sheet name.
    Please Login or Register  to view this content.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Registered User
    Join Date
    03-23-2015
    Location
    Swansea, Wales
    MS-Off Ver
    2014
    Posts
    19

    Re: button to save as new work sheet

    Awesome thanks!

+ 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 one sheet, and save work book as back up
    By ryanlee84 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2014, 03:58 AM
  2. Excel 2007 : save button on a work sheet
    By zinctek in forum Excel General
    Replies: 2
    Last Post: 09-06-2010, 02:32 AM
  3. disable save and saveas but have submit button to save file as work
    By briant97 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2010, 12:32 PM
  4. [SOLVED] Save button will not work- greyed out?
    By jsncpa in forum Excel General
    Replies: 2
    Last Post: 06-19-2006, 04:25 PM
  5. [SOLVED] Spin button in a work sheet - how do I make it work?
    By [email protected] in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2005, 04:06 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