Moving sheets to another workbook
Hi!
I have a source workbook which creates 25 to 30 worksheets, each one's name
ends with "P1"
I want to move these sheets to an existing destination workbook, through a
vba sub residing in the source workbook
BUT :
if one or the source worksheet exists in the destination workbook, it
should be replaced by the new one
I've tried to code that, but Excel generates an error and closes.
Any idea for coding that ?
Thanks by advance,
Herve+
|