Saving .xls without macro

[sk8rider]

Hello,


I did a search for this issue, but I can't find anything related t
it.

This is my issue:

I have an .xlt which contains macro, at the end of the macro I save th
resulting sheets as .xls. The resulting sheets are saved with origina
macro. I wonder is there a way that I could save the file without th
macro.

I am using this code to save my file as .xls.

File_Save_Name = Sheets("Menu").Range("D6").Value & Format _(Now
"mmddyy") & ".xls"

ActiveWorkbook.SaveAs FileName:=File_Save_Name, FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False _
, CreateBackup:=False

any help would be greatly appreciated.

Thanks in advanc

 

[Gord Dibben]

Check out Chip Pearson's site for code to delete macros from a workbook.

http://www.cpearson.com/excel/vbe.htm

Gord Dibben Excel MVP

 

[sk8rider]

Thanks Gord Dibben for your reply. It did helped