ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Linking from a Combo box to another excel file's specific workshee (https://www.excelbanter.com/excel-programming/403591-linking-combo-box-another-excel-files-specific-workshee.html)

James from Sage

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