Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
Turn off/on auto calc when entering or leaving a specific workshee | Excel Programming | |||
Linking Special Formats from One Worksheet to a Different Workshee | Excel Discussion (Misc queries) | |||
Search for a specific file's extension | Excel Programming | |||
excel 97: linking 2 combo boxes | Excel Programming |