![]() |
|
|
|||||||
| FlashChat | Actuarial Discussion | Preliminary Exams | CAS/SOA Exams | Cyberchat | Around the World | Suggestions |
|
![]() |
|
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
|
I have a spreadsheet with a bunch of hyperlinks. What I want to do is to have a macro open these links one at a time in Excel.
Code:
Workbooks.OpenText <URL> |
|
#2
|
|||
|
|||
|
Option Explicit
Sub openLinks() Dim hl As Hyperlink For Each hl In ActiveSheet.Hyperlinks hl.Follow Next hl End Sub |
|
#3
|
||||
|
||||
|
Thanks!
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|