Links and users

[Joyce]

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?

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy




"Joyce" <[email protected]> wrote in message
news:[email protected]...
> 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?