By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,988 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,988 IT Pros & Developers. It's quick & easy.

GetSaveAsFilename making trouble!

P: 8
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
Share this question for a faster answer!
Share on Google+

Post your reply

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