vba substitution operator/ changing query string

[Adam Gotch]

Hello All:

Can anyone tell me how to loop through a list of queries and change the
query string with some kind of substitution subprocedure. Also is there a
pattern matching operator in VBA?

Thanks,

Adam