Re: [ExcelVBA] saving files either as XLS or XLSM

 

Hi

Try it *filename.xlsx*

On 7 March 2013 10:02, sunnywulf <wolfram.schneider@maximintegrated.com>wrote:

> **
>
>
> 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
>
>
>

[Non-text portions of this message have been removed]

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

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

.

__,_._,___