SaveAs Method in EXCEL 07


M

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.
 
J

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
 
Last edited by a moderator:
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top