excel vba

[mjschukas]

i would like to bring up the file save as dialog box and defalut to a
file type of xls..

here's what i'm using...
'i have a path and file name in Newfile
NewFile = Application.GetSaveAsFilename(myfilename, "*.xls")

thank you...!

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Frank Kabel]

Hi
try
newFile = Application.GetSaveAsFilename(Initialfilename:=myfilename, _
fileFilter:="Excel Files (*.xls), *.xls")