Look at the ChangeLink method and the LinkSources in Excel VBA help.

--
Regards,
Tom Ogilvy




"Joyce" wrote in message
...
I have a workbook that links to three external workbooks. I'd like to
create
a userform where the user could just enter the correct file name (without
having to go to the drop down menus from the tool bar). Is there a way to
do
this?