copy active sheet to another workbook/file

[young_86]

Hi,
I got to file (file1; file2). both of them are on disc C:/. I need to copy active sheet from file1 to file2. but in situaction when in file2 sheet with the same name exist i want to replace it, if not copy sheet and paste ad the end (move to end).
eg. i copy from file1 sheet 'name1' to file2. if in file2 sheet 'name1'already exsit eplace it; else paste sheet 'name1' at the end.
oh, and name of sheet is taken from cell B3 from sheet 'name1' in file1.

I know how to do it teoreticly but when it came to practice i received only errors.
Thank you in advance for help.

[marreco]

Hi.

while the folks does not answer, read on:
https://sites.google.com/a/madrocket...ch-sheet-to-wb
https://sites.google.com/a/madrocket...ssistant/files

[JBeaucaire]

The simplest thing to add to your existing macro, right before your COPY command, simply DELETE the existing sheet. If you turn off errors for a moment, then delete the sheet, then turn errors back on to the state you had them before, then if you try to delete a non-existent sheet, the macro will just keep going.