View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nick Cranham Nick Cranham is offline
external usenet poster
 
Posts: 62
Default GetSaveAsFilename - how to code the arguments

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

"L Mehl" wrote in message
...
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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.591 / Virus Database: 374 - Release Date: 2/18/2004