Im not a rookie but sometimes you encounter problems that you have not had before..
Why can I not save a File with GetSaveAsFilena me 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").Val ue 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.Get SaveAsFilename( _
initialName:=De alername _
fileFilter:="Ex cel Files (*.xls), *.xls")
Why can I not save a File with GetSaveAsFilena me 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").Val ue 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.Get SaveAsFilename( _
initialName:=De alername _
fileFilter:="Ex cel Files (*.xls), *.xls")