[AccessD] OT - Changing a DSN Connection

To all,

We are having a new server (very soon) and changing the name to something
like AL-MASTER from AL-ORR the thing is I have a lot of Excel management
reports which use various DSN's pointing to AL-ORR, is there something I
could write in Access or VB that a a click of a button will find these DSN's
and replace the server name ?

Any help on this would be greatly appreciated.

Thanks in advance 

Paul Hartland

P.S. Happy New Year to all list members, don't know what I would do without
it sometimes