Does anyone know how to change links in Excel with VBA and
using variable names ??

I have an application that moves from one server to
several others. I can create the path that is the current
link as

Current_link_name

I can also create the target link to change to as

New_link_name

My problem is in getting VBA to change the links with the
two variable names, without "hard-wiring" the names into
the command.

Any thoughts ?