GetSaveAsFilename - how to code the arguments

[L Mehl]

Hello --

I want to use GetSaveAsFilename to prompt the user to select a filename (for
use or easy modification) to pass to SaveCopyAs so the the current Workbook
can be backed up.

This code
strFileIn = Application.GetSaveAsFilename( _
InitialFilename:="*.xls" , _
FileFilter:="Excel Files (*.xls), *.xls ") , _
Title:= con_strMsgTitle & " Save Plot and Data")

results in 'Expected: End of Statement"

I found the FileFilter structure in MSDN, and figured out the
InitialFilename and Title structures. They each work alone, but not
together.

Can someone help me by telling me how to fix the code, or how to simply put
the parameter values in the correct order in parentheses.

Thanks for any help.

L Mehl

 

[Harald Staff]

Hi L

Replace
*.xls ")
with
*.xls)"

 

[Nick Cranham]

L,
I'd suggest you count the barckets.
NickHK

 

[L Mehl]

Apologies for posting code which had parenthesis errors.

Thanks to Harald, Nick, and MSDN PSS ID Number: 153722,
the structure that works is:
strFileIn = Application.GetSaveAsFilename( _
InitialFilename:="*.xls" , _
FileFilter:="Microsoft Excel Workbook (*.xls), *.xls" , _
Title:= con_strMsgTitle & " Save Plot and Data")

L Mehl