I'm trying to create a basic main page for a few macros in my access database. There are two macros that both require it to fetch data/export data onto another excel sheet.
Everything works well assuming that the files do not change their location, but I would like to give the user the option to change the file path if they desire.
e.g. i would like to have a space with the current default file path, and if they wish to change it, then they can click a button to go to file manager and choose the file path to overwrite the default file path.
would this be possible? Basically, i just need a way to access the explorer and when a user click on a file, it'll save that file path as the new file to export/import data onto.
Also, if that is possible, how do i save the data so that my macro can access this "path"? Thanks!