How to set the SaveAs dialog box to a specific directory

Good day to all, I am currently working a on an Excel file which has an event which allows the user to save the file with a pre-determined name, this is done using hte Workbook_BeforeClose event.

Everything is working fine except that I am trying to set a specific directory path and don’t seem to be able to do it.

All I can get the SaveAs dialog box to display is folders starting from the Desktop.

Any help at all would be greatly appreciated.