![]() |
Linking from a Combo box to another excel file's specific workshee
I'm using the following code to access a worksheet from a combobox
Private Sub SourceDocLinksComboBox_Change() If SourceDocLinksComboBox.Value = "Net Promoter - Overall" Then SourceDocLinksComboBox.Value = SourceDocLinksComboBox.List(0, 0) ActiveWorkbook.FollowHyperlink Address:="file:///\\Path\Path\Some excel fil.xls#Sheet3!A1", _ NewWindow:=True End If ... It works fine when I don't try and specify the worksheet but breaks down when I add #Sheet3!A1 Any ideas? Thanks, - James |
All times are GMT +1. The time now is 11:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com