467,161 Members | 856 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

GetSaveAsFilename making trouble!

Im not a rookie but sometimes you encounter problems that you have not had before..

Why can I not save a File with GetSaveAsFilename where the initialname is used AND filefilter set to Excel files??

The initialname is a variable and is supposed to be a optional variant if you see the definition of the method. Dealername is coming from a Range("A3").Value from the file that is to be saved and renamed.

Can you help me? Try it out - it makes nonsense!

PS. If i take out initialname = it works. If i take out filter = it works. But not both at the same time....??



fileSaveName = Application.GetSaveAsFilename( _
initialName:=Dealername _
fileFilter:="Excel Files (*.xls), *.xls")
Nov 28 '06 #1
  • viewed: 1094
Share:

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

26 posts views Thread by meltedown | last post: by
90 posts views Thread by Ben Finney | last post: by
351 posts views Thread by CBFalconer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.