Question Locked

How to set the SaveAs dialog box to a specific directory

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

This discussion is closed to new replies.