Hey everyone, thanks for any time or assistance, I'm a complete novice when it comes to this stuff.
I'm attempting to run a script in Excel that automatically opens a large amount of hyperlinks. Both scripts I'm attempting to use are from here: 3 Easy Ways to Batch Open Multiple Hyperlinks in Your Excel - Data Recovery Blog
The scripts I've tried are this, for a selected highlighted range in the file
and
I've made sure to change the security preferences to allow for VBA scripts/macros to run, but I'm still unsuccessful. I've tried implementing the code in a Module, in the Workbook itself, and in the individual Worksheet, and I'm still not getting anywhere.
Does anyone know what could be causing these to fail? I'm not getting any kind of error message that would begin to point me in the right direction. Every time I click "Run" (from VBA or from the Excel document), simply nothing happens.
Again, any help is appreciated.
I'm attempting to run a script in Excel that automatically opens a large amount of hyperlinks. Both scripts I'm attempting to use are from here: 3 Easy Ways to Batch Open Multiple Hyperlinks in Your Excel - Data Recovery Blog
The scripts I've tried are this, for a selected highlighted range in the file
VBA Code:
Sub BatchOpenHyperLinks_SelectedRanges()
Dim objSelectedRange As Excel.Range
Dim objHyperlink As Excel.Hyperlink
'Get selected ranges
Set objSelectedRange = Excel.Application.Selection
For Each objHyperlink In objSelectedRange.Hyperlinks
objHyperlink.Follow
Next
End Sub
and
VBA Code:
Sub BatchOpenHyperLinks_Workbook()
Dim objWorksheet As Excel.Worksheet
Dim objSelectedRange As Excel.Range
Dim objHyperlink As Excel.Hyperlink
'Process each worksheet
For Each objWorksheet In ThisWorkbook.Sheets
For Each objHyperlink In objWorksheet.Hyperlinks
objHyperlink.Follow
Next
Next
End Sub
I've made sure to change the security preferences to allow for VBA scripts/macros to run, but I'm still unsuccessful. I've tried implementing the code in a Module, in the Workbook itself, and in the individual Worksheet, and I'm still not getting anywhere.
Does anyone know what could be causing these to fail? I'm not getting any kind of error message that would begin to point me in the right direction. Every time I click "Run" (from VBA or from the Excel document), simply nothing happens.
Again, any help is appreciated.