Solved

vba to save xls file without macros

Posted on 2012-03-20
5
224 Views
Last Modified: 2012-03-21
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!
0
Comment
Question by:etech0
  • 3
  • 2
5 Comments
 
LVL 6

Expert Comment

by:wshark83
ID: 37742960
have you tried just changing the xlsx extention to xls...?
0
 
LVL 10

Author Comment

by:etech0
ID: 37742980
Will it then save without the macro?
0
 
LVL 10

Author Comment

by:etech0
ID: 37742991
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
 
LVL 6

Accepted Solution

by:
wshark83 earned 500 total points
ID: 37743378
0
 
LVL 10

Author Closing Comment

by:etech0
ID: 37749764
Thanks!
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now