Links and users
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? |
Links and users
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? |
All times are GMT +1. The time now is 09:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com