Try turning on the macro recorder and recording the action you want to take.
If you need help cleaning it up, post it here.
--
HTH,
Barb Reinhardt



"Ben" wrote:

Hi all,

I have two workbooks A and B. When the user opens workbook A, I would like
to have Workbook A to create a link to worksheet1 from workbook B, which
resides out on the network. I tried various UNC path syntax to workbook B,
but it didn't work.

Can you share your thoughts on enabling this to happen programmatically on
opening workbook A? Thanks for sharing your thoughts.

Ben


--