vba to save xls file without macros

Hi!
I have an excel file containing a macro. As the last step, the macro saves the file as an xlsx, so that it can be distributed via email without the macro.
I now need to duplicate this for users in Excel 2003. How can I do this?
Here is my current code:

Application.DisplayAlerts = False
Application.EnableEvents = False
    ActiveWorkbook.SaveAs Filename:= _
        "F:\buying\catalog production\2013\" & FName & ".xlsx", FileFormat:=xlOpenXMLWorkbook, ReadOnlyRecommended:=False, CreateBackup:=False
Application.EnableEvents = True
Application.DisplayAlerts = True

Open in new window


Thanks!
LVL 10
etech0Asked:
Who is Participating?
 
wshark83Commented:
0
 
wshark83Commented:
have you tried just changing the xlsx extention to xls...?
0
 
etech0Author Commented:
Will it then save without the macro?
0
 
etech0Author Commented:
I tested it - it saves with the macros. What I need is for it to save without, so I can email it to many people without encountering 'email' issues.
0
 
etech0Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.