If sheets exists in another workbook overwrite it

**Mistweaver** · 11-26-2009, 06:01 PM

I have the following code which copies a sheet to another workbook and renames it with the current date. However I need it to check if there is a sheet already existing in the other workbook with todays date first. If there is then it should delete the old sheet and copy the new sheet or just overwrite it.

Please Login or Register  to view this content.

**protonLeah** · 11-27-2009, 01:27 AM

Please Login or Register  to view this content.

**Mistweaver** · 11-27-2009, 12:27 PM

Thanks a lot.

I have incorporated it into my code however my head is now smoking because I am not copying the sheet into the other workbook ("Head Count.xls") anymore. It is copying it to the end of the active workbook ("Shared Pit.xls").

How can I change the code to copy the active sheet in ("Shared Pit.xls") into the other workbook ("head count.xls") and not the active workbook ("Shared Pit.xls")

Here's my code. I appreciate all help greatly.

Please Login or Register  to view this content.

**romperstomper** · 11-27-2009, 12:45 PM

Try this:

Please Login or Register  to view this content.

**Mistweaver** · 11-27-2009, 12:57 PM

Thanks for the help.

Works perfectly. Many thanks mate.

If sheets exists in another workbook overwrite it

LinkBack

Thread Tools

Rate This Thread

Display

If sheets exists in another workbook overwrite it

Re: If sheets exists in another workbook overwrite it

Re: If sheets exists in another workbook overwrite it

Re: If sheets exists in another workbook overwrite it

Re: If sheets exists in another workbook overwrite it

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions