| 0 |
Subject: Excel Macro: Converting Hyperlink problem
Posted by: allhair allstars
- Sustainer [50902421] Tue, Apr 04, 2006, 00:07
I could use a hand resolving what I hope is a minor issue. Given my knowledge base, this probably nothing, but...
I have the following macro that converts hyperlinks into text addresses, i.e., from "Yahoo!" to "http:\\www.yahoo.com".
My problem is that it while it works like a charm in my Excel2K, my Excel97 spits it back out at me.
Does anyone have a way to do the same thing in a way that will work in Excel97?
TYIA!
Sub ConvertHyperlinks()
Dim h As Hyperlink
For Each h In Worksheets(1).Hyperlinks
h.TextToDisplay = h.Address
Next
End Sub |
| 1 | RecycledSpinalFluid
Dude
ID: 204401122
Tue, Apr 04, 2006, 01:56
|
Does this help?
|
| 2 | allhair allstars
Sustainer
ID: 50902421
Tue, Apr 04, 2006, 07:50
|
Not yet, but I'll keep at it.
Thanks...
|
| 3 | allhair allstars
Sustainer
ID: 50902421
Wed, Apr 05, 2006, 10:59
|
Guess I'm going to need a little more direction on this one. At this point I'm switching to Excel2000 to run the macro in question, but certainly there's a better way to do this. Any help appreciated...
|
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|
|