Overwrite existing excel sheets

**med1234** · 08-14-2011, 03:50 PM

Referring to this forum posting http://www.excelforum.com/excel-prog...ll-values.html and the code (see below), I would like to ask, if anyone may help to change the code so that the macro does not overwrite existing sheets in an excel file. For example, if I have three sheets in an excel file, and I am running the code on sheet1, it should be avoided that sheet2 and sheet3 are overwritten and instead new sheets should be created.

Please Login or Register  to view this content.

[/QUOTE]

**MarvinP** · 08-14-2011, 04:01 PM

Hi,

See if this link helps with your code.
http://www.ozgrid.com/VBA/IsWorkbookOpen.htm

**med1234** · 08-14-2011, 04:09 PM

Originally Posted by MarvinP

Hi,

See if this link helps with your code.
http://www.ozgrid.com/VBA/IsWorkbookOpen.htm

yes, indeed that may help!!! DoesSheetExist should check if the sheet exists, any idea how this information can be used, not to overwrite an existing one and to create a new one? I am so sorry... it seems quite complicated for me as a beginner to solve this problem :-(

**MarvinP** · 08-14-2011, 07:43 PM

If the sheet exists then create a new one. I'd turn on my macro recorder and create a new sheet to see what code is generated.

I hope that helps. It is just hard to read someones code without seeing the sheet names and getting an idea of what is supposed to happen.