Macro to 'Change' & 'Save' Queries

Hello all,

We have our own ERP system which is maintained by our parent company.
About 3 times a year we get upgrades in which even the file layouts are
changed. Due to this we need to change all our queries. Instead of
changing every query I create an XL file with queries that have been used
on the last 6 months. Has anyone developed a macro in Client Access (I
have one in Extra Personal Client) which would read through an XL file,
call each query for change & then save. The only problem is that very
often some queries do not have the required files on-line in which case
the macro fails. I need to decide manually if the query needs to be saved
of skipped.

Any ideas ??

Thanks & best regards
Ewart