The default folder is specified in the Tools | Options menu, "Default Database Folder."
Manually set it, or run a macro (using Sendkeys) which sets that value. You could also them run the macro converter to convert that macro to VBA (Tools | Macro | Convert Macros to Visual Basic).