Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Fill in a brief DW Simpson Registration Form
to be contacted when our jobs meet your criteria.


Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2005, 01:06 PM
Course 4 Escapee's Avatar
Course 4 Escapee Course 4 Escapee is offline
Member
 
Join Date: Nov 2001
Location: Milky Way
Posts: 2,897
Question Excel VBA: Hyperlinks

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>
Since the text of the hyperlinks is not the URL address, how do I get Excel to recognize the URL?
Reply With Quote
  #2  
Old 09-08-2005, 01:33 PM
dumples dumples is offline
Member
 
Join Date: Sep 2003
Posts: 1,073
Default

Option Explicit

Sub openLinks()
Dim hl As Hyperlink
For Each hl In ActiveSheet.Hyperlinks
hl.Follow
Next hl
End Sub
Reply With Quote
  #3  
Old 09-08-2005, 01:42 PM
Course 4 Escapee's Avatar
Course 4 Escapee Course 4 Escapee is offline
Member
 
Join Date: Nov 2001
Location: Milky Way
Posts: 2,897
Thumbs up

Thanks!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 09:20 PM.


Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.22527 seconds with 7 queries