+ Reply to Thread
Results 1 to 4 of 4

copy file to more than one directory and remove sheets

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    36

    copy file to more than one directory and remove sheets

    Earlier, I received this code to copy a file to another directory. Works perfectly !

    Please Login or Register  to view this content.
    I now wish to go further :

    ON TOP OF THIS, I also which to copy the same file to yet another folder AND remove some sheets in this new copy (in other words : only copy one sheet of the file).

    What the copying itself is concerned, I already discovered that just copying the above code is not good, it reports an error, seems that it seems to perceive it as a double instruction, which makes sense.
    Last edited by jokkebal; 01-08-2018 at 07:23 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524

    Re: copy file to more than one directory and remove sheets

    If you want to just save a worksheet.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-20-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: copy file to more than one directory and remove sheets

    is quite simple but with some additions, it should work. thanks.

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,514

    Re: copy file to more than one directory and remove sheets

    Shouldn't it be ?
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. Copy row from several workbooks in directory, edit then savedata in both sheets.
    By KidZest in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2017, 07:05 AM
  2. [SOLVED] How do I copy a file to the same directory?
    By Lee-337 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2013, 01:59 AM
  3. copy file to a directory if cell G6 equals to a certain value
    By w8itn4you in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2012, 06:58 PM
  4. Replies: 1
    Last Post: 09-26-2012, 09:37 AM
  5. when the file in Directory exists then copy the immediate cells.
    By kate.middleton1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2012, 05:04 AM
  6. Copy Most Recent File to another Directory
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-14-2009, 12:51 PM
  7. Replies: 3
    Last Post: 06-11-2009, 07:08 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