SaveAs Method in EXCEL 07

[Manuelauch]

When I use the statement:
ActiveWorkbook.SaveAs Filename:="C:\TEMP\TEST.xlsm" ' save as .xlsm

to save a file (with a lot VBA codes) that has not been saved before I get
foloowing error:
The following features cannot be save in macro-free workbooks:
..VB project
To save files with this features, click No, and then choose a macro-enabled
file type in the File Type list.

To contine saving as a macro-free workbook, click Yes.

 

[Jan Karel Pieterse]

Hi Manuelauch,

> When I use the statement:

> ActiveWorkbook.SaveAs Filename:="C:\TEMP\TEST.xlsm" ' save as .xlsm
> to save a file (with a lot VBA codes) that has not been saved before I get

> foloowing error:

> The following features cannot be save in macro-free workbooks:

> ..VB project

See: http://www.rondebruin.nl/win/s5/win001.htm

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[pstraton]

Ron de Bruin has rearranged his web site. I believe the intended link is now at: http://www.rondebruin.nl/win/s5/win001.htm