View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default SaveAs without closing original workbook

I forgot to mention that the workbook to be cloned contains the cloning Sub,
so Thisworkbook is to be cloned!

Stefio


€žStefi€ť ezt Ă*rta:

Hi All,

I want to clone a workbook in several copies with different file names, and
also I want to keep the original workbook open during the process and
activate it again at the end of the process. SaveAs works, but closes the
original.

Thanks,
Stefi