Hello all,

I'm searching for a solution to safe an xslx-Excel File out of VBA.
The Filename is predefined as "NewFilename"
The final folder to save the file is not available or has a different name.

Because of this a window shall open for "K:\Main\Sub1\Sub2" and the User shall either be able to save the file "NewFilename" here (and move it later to final folder) or to select/create the correct "Sub3"-Folder and save it.

How can I write that code?

Thanks in advance.

Stefan