ThisWorkBook.SaveCopyAs minus the VB Code

[shanep]

Hi

Is it possible to us .SaveCopyAs to save a copy of an existing workbook but in doing so remove all the VB in the saved copy of the workbook?

The reason I ask is that I have a workbook which I need to save a copy of, then open and delete most of the sheets. However, the workbook from which the copy is being created contains code in the workbook.open event and so when I open the copy to delete the sheets (which I want to occur without user intervention) the workbook.open code fires up (and prompts the user for input - which the code is designed to do) ...

Thanks
Shane

 

[Andrew Poulsom]

You could copy the sheets you want to a new workbook and save that.

 

[shanep]

Hi Andrew, thanks for the quick response.

Yeah, I did think of that but it just seemed a bit easier to copy the lot then delete the ones I didn't want.

I was also curious as to whether it was possible. Do you know?

 

[hirvenhuuli]

I have the same question?

 

[micro-blades]

Open the 2nd workbook using:

Application.EnableEvents =False
workbook.open("")
Application.EnableEvents = True

This will keep the second workbooks' code from firing.

Brian