Load Dialog Box in the last directory path opened

[Inti]

I have a file which is opened every so often. This file when opened it presents a userform in which you browse two files which then get loaded into the document and some charts/pivots are updated with the information from the loaded files.

When you click on the browse button it opens the browser dialog box in the libraries path. I am wondering if it's possible to have the dialog box open in the last directory path used.

For example:

A week ago I opened the file from the path C:\Users\Inti\Documents\Projects\Tea Project

What I would like to happen is that when I open the file today and I click the "Browse" button (which opens the dialog box to find files in your computer) for the dialog box to open automatically in the path C:\Users\Inti\Documents\Projects\Tea Project

Then if tomorrow the file is opened from the path C:\Users\Inti\Pictures\Projects\Tea2Project
Then a week from now when you browse for the file the dialog box opens automatically in the C:\Users\Inti\Pictures\Projects\Tea2Project path

This is what I have right now and it always opens the dialog box on C:\Users\Inti\Documents

Please Login or Register  to view this content.

[Tinbendr]

The only way to accomplish that is to store the path somewhere. A cell, worksheet property (like Author), or worksheet variable.

Then upon opening, recall the value and change the current path.

In the ThisWorkbook module:

Please Login or Register  to view this content.

When GetOpenFilename opens, it will be at the stored path.

Then, in the browse event of the userform, store the path back to the property.

Please Login or Register  to view this content.