+ Reply to Thread
Results 1 to 2 of 2

Copy Entire worksheet to another folder

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    37

    Copy Entire worksheet to another folder

    I want make a entire copy of one worksheet, by clicking in one button.
    The problem its the source name of the folder are all week diferent.

    Example.

    Resume WK22.xlsm - source
    Resume WK22 ReadOnly.xlsm - Destiny

    next week

    Resume WK23.xlsm - source
    Resume WK23 ReadOnly.xlsm - Destiny
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Copy Entire worksheet to another folder

    The code for MettiProtezioneTutto is not revealed here and that seems to be what we should see
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. VBA macro code hel to save a copy all sheets or entire file in a folder
    By sctr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2017, 07:44 AM
  2. Search worksheet for #N/A values, when foud copy entire row to another worksheet
    By ChelseaC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2014, 03:35 PM
  3. [SOLVED] To search in all the excel files in a folder and if find in any cell copy the entire row
    By tameen42 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-15-2014, 08:46 AM
  4. Save entire workbook as copy in specific folder with VBA
    By cychua in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2012, 08:35 AM
  5. [SOLVED] Copy entire row in one worksheet, paste in next blank row in another worksheet
    By dev111ski in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2012, 01:02 PM
  6. Drop Down List to Copy Entire Contents of Worksheet into Master Worksheet
    By mrmartin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-14-2011, 10:54 PM
  7. Copy Paste Values For Entire Folder of Workbooks
    By Mick S in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2011, 02:27 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