I need a macro to open a file, but I don't want to hard code the path.

I have a Summary workbook the pulls data from new workers' logs via a macro called "Updateme"

Currently, I need to update the "Updateme" macro in the summary work book for each hire group with the path to the directory where their training logs are located.

I will be promoting out of my current position and will be handing the duty of maintaining these logs off to a co-worker.

I want to code the updater so that the path to the logs does not need to be hard coded, but is variable as each hire group gets its own folder. My initial thought was to code a field in List.xlsx with the path listed for each worker, but then I realized that the path to List.xlsx is what I need to make indeterminate!

I had the idea to use "Application.GetOpenFilename("*.xlsx") but I don't want the user to have to find the list.xlsx file every time.

Is it possible to have the macro pull the directory from "Application.GetOpenFilename("*.xlsx") using something like:

Please Login or Register  to view this content.

and then have the macro write the directory or path in the macro for the future, once the path is known?

Any ideas on how to do this?

The relevant part of my existing macro is below.

Please Login or Register  to view this content.

Thanks for any help or ideas!