Hi everyone,

I have a spreadsheet with a number of embedded queries from Access.

The database that generates the queries may be moved and/or have its name changed.

Without having to manually delete and re-load each embedded query or change the filepaths manually in the properties section for each one individually, is there VBA code that will tell Excel to reference the new database filepath?

I've looked over a few online but none seem to work on my machine - I'm wondering if there's something I'm missing.

Many thanks,
Paul