Export word file prompting a dialog box save location

I have the following code that takes information from excel and creates a word file and saves it automatically to a specific location.

I need it to keep the same file name from the specific cells listed but instead of auto saving to a location I want it to prompt me with a save as dialog box so that I can select the location to save the word document to without changing the excel workbook location

Please Login or Register  to view this content.

Any Help Would be appreciated

thanks,

Matt