J
James from Sage
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
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