View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
affordsol affordsol is offline
external usenet poster
 
Posts: 29
Default 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+