Query Refresh

[Chas]

I currently have a workbook that has several Query Tables in it. I currently
have a macro to "refreshall" but my problem is that occasionally the file
name may change causing an error in the refresh process. Is there a way to
include a procedure in code that if the filename in the query no longer
exist, it could prompt for the correct filename? In my existing macro I have
a section for inserting new queries & it prompts for the filename but I'm not
sure how to code on a refresh error to prompt for a filename.

Any help would be greatly appreciated.

 

[Don Guillett]

Maybe instead of refresh all refresh each in turn with an on error goto