Embedded queries - changing the connection filepath when a database is moved

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, is there VBA code that will tell Excel to reference the new database filepath?

Many thanks,
Paul

thanks mate - just reposted it as you suggested.