I want to have the application.showOpenDialog (or similar) in excel to start in a predetermined folder. I'm having trouble because:

1 - The only method I found was to change the actual default path, which would not be a plus for a program
2 - Method 1 doesn't work (and I won't use it anyways), I recorded a macro of changing the filepath but apparently if I set it using code it doesn't "get through" to excel (maybe events were off?).

Does anyone know how to have it open where I want it to?