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")
|