VBA - Save File Location Prompt

Good Afternoon,

Please can anyone help, I'm going in circles a little bit. I have some code below which creates and saves some information from one sheet to a new CSV workbook.
I would like it to prompt the save location but keep the Filename I have given it (

Please Login or Register  to view this content.

)

Can anyone help?

Please Login or Register  to view this content.

As always, all help is greatly appreciated.

Tom

Thanks AlphaFrog. Works a treat.

Tom