[ExcelVBA] saving files either as XLS or XLSM

 

I am struggling with this and and hope somebody can help.

A workbook in Excel versions 2003, 2007 or 2010 has macros and need to
be saved. In the Before_Save event I check for the excel version and
only allow saving as XLS for 2003 or XLS or XLM (due to macros) for 2007
and 2010 version.

For 2003, it is easy:
FName = Application.GetSaveAsFilename(FileFilter:="Excel 97-2003
Workbook (*.xls), *.xls")

But what is the proper command for 2007 and 2010 to set two file
filters? The following doesn't work:
FName = Application.GetSaveAsFilename(FileFilter:="Excel Macro-Enabled
Workbook (*.xlm), *.xlm", "Excel 97-2003 Workbook (*.xls), *.xls")

Your help is greatly appreciated.
Wolfram

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___