File Format equals Marco-Enabled Workbook

**markcicoff** · 02-05-2009, 06:04 PM

Within my VBA code, I want to save the Excel file as "Excel Macro-Enabled Workbook." Currently, File Format:=xlNormal within the VBA code and the results saves the Excel file as .xls. How do I write the File Format to save the Excel file as "Excel Macro-Enabled Workbook."

Below is an example:
ActiveWorkbook.SaveAs Filename:=Left$(ActiveWorkbook.Name, (Len(ActiveWorkbook.Name) - 4)), FileFormat:=xlNormal, CreateBackup:=False

**dominicb** · 02-05-2009, 06:14 PM

Good evening markcicoff

Originally Posted by markcicoff

Within my VBA code, I want to save the Excel file as "Excel Macro-Enabled Workbook." Currently, File Format:=xlNormal within the VBA code and the results saves the Excel file as .xls. How do I write the File Format to save the Excel file as "Excel Macro-Enabled Workbook."

Unfortunately, there is no such thing as a macro enabled workbook. A user can control his / her own macro security settings and determine whether macros can be run or not.

It's a deliberate thing by Microsoft in the name of security and it's non negotiable.

HTH

DominicB