Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking worksheets programmatically
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 -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking worksheets programmatically
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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding worksheets programmatically | Excel Programming | |||
Linking worksheets | Excel Discussion (Misc queries) | |||
Setting a Worksheets Codename to a variable programmatically | Excel Programming | |||
Retrieving list of worksheets programmatically | Excel Programming | |||
Programmatically addressing worksheets - painfully stupid question | Excel Programming |