SaveAs problem in 2007

[brindle1121]

I have a VBA macro that says....

Application.VBE.ActiveVBProject.VBComponents.Import ("C:\..etc..")
ActiveWorkBook.SaveAs Filename:=ActiveSheet.Name


I'm riunning the macro in XL 2007 which I have configured to use .xls formats. I would assume this Excel 2007 formats any new workbook file in .xls. always. Is this correct?

I'm, using an Import and Export command to move other macro code in another module from the source workbook into each new workbook. This all works fine in XL2003.

But running the macro in XL 2007 I get the following error message:

======================================
The following features cannot be saved in the Macro free
worksheet:

VBProject

To save a file with this feature, click No and choose a macro-enabled
file type.
=======================================

Why am i getting this error message? Is thers something special about ActiveVBProject?

 

[RoryA]

Try using:

ActiveWorkBook.SaveAs Filename:=ActiveSheet.Name, xlworkbooknormal