Linking from a Combo box to another excel file's specific workshee

  • Thread starter James from Sage
  • Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top