VBA Code - Opening the save as window

[Peggy2015]

Hello,
How do I write a code to activate the 'Save as' window and a certain location. the name of the file will always be different that I want to save it as, but the file path will more or less be the same.

Thanks for your help.

Best wishes,
Peggy

 

[shg]

See Help for Application.GetSaveAsFilename

 

[Peggy2015]

Hello,

This is not what I was looking for. I know how to save a workbook as a macro. My query is how do I write a code to activate the 'Save as' window so I can save the macro enabled workbook in a certain location.

I hope you can help.

Best wishes,
Peggy