+ Reply to Thread
Results 1 to 2 of 2

Button To Save Copy of Excel File in Designated Folder

  1. #1
    Registered User
    Join Date
    08-27-2018
    Location
    London
    MS-Off Ver
    office 2016
    Posts
    45

    Button To Save Copy of Excel File in Designated Folder

    Hello

    I am looking for code that would save a copy of the excel file in a designated folder
    say there are two folders

    Desktop/Current
    Desktop/FinArchive

    Say the file is called AccountsP1W1.xlsm, when a button within the file is pressed the file will then save a copy with the word archive added to the end of itself in FinArchive folder called AccountsP1W1archive.xlsm

    The button would be in the SETUP tab

    Ideally a confirmation pop up (any any kind of confirmation) that the operation is completed successfully would be handy but not essential, or that
    Attached Files Attached Files
    Last edited by diddy47; 09-22-2019 at 11:34 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-02-2012
    Location
    London, England
    MS-Off Ver
    365
    Posts
    397

    Re: Button To Save Copy of Excel File in Designated Folder

    Maybe something like this:

    Please Login or Register  to view this content.
    Beth.

+ 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: 1
    Last Post: 01-03-2018, 12:53 PM
  2. shell to search for a designated term in a designated folder
    By drech in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2016, 01:33 PM
  3. [SOLVED] Saving an Excel file in a designated folder
    By Buddy8 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-19-2016, 07:52 PM
  4. Save Button that looks up latest file in folder, adds one and saves
    By Kucster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2014, 11:55 AM
  5. [SOLVED] Lookup folder from cell text, then save excel file in this folder
    By dodgybob in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2014, 09:00 AM
  6. Add a new folder with Save File Button command VBA
    By RichardJSigKits in forum Excel General
    Replies: 4
    Last Post: 05-06-2014, 10:43 AM
  7. Replies: 0
    Last Post: 04-21-2014, 04:03 PM

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