copy file to more than one directory and remove sheets

[jokkebal]

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.

[davesexcel]

If you want to just save a worksheet.

Please Login or Register  to view this content.

[jokkebal]

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

[bakerman2]

Shouldn't it be ?

Please Login or Register  to view this content.