Hello,

I'm currently blocked on this issue :
sFileSaveName = Application.GetSaveAsFilename(InitialFileName:=***, fileFilter:="Excel Files (*.xlsx), *.xlsx")
This opens a Save as dialog box, which is fine,
The file name is automatically generated ("***") which is also what I want,

But the default folder is C:/My Documents

This is not what I want. I want a default folder based on a server where the user can chose the folder where he wants to save the file.

Thanks for your help.