PC Review


Reply
Thread Tools Rate Thread

How do I display the link location of a hyperlink?

 
 
=?Utf-8?B?UmVsaWM0MjY=?=
Guest
Posts: n/a
 
      28th Oct 2006
I have an excel application that queries a web site and downloads certain
tables as html.. The tables contain hyperlinks, the location of which you
can view if you mouse over them and by clicking on the cell, you can also
follow these links.

But what is actually displayed in the cell is the "friendly name". For
future programming, I would like the actual link location displayed (either
in these cells or different cells)... Does anyone know a way to do that?

I've tried edit query, but excel vba learn doesn't record the link location??
 
Reply With Quote
 
 
 
 
=?Utf-8?B?R2FyeScncyBTdHVkZW50?=
Guest
Posts: n/a
 
      28th Oct 2006
Here is a one-liner:

Function hyp2(r As Range) As String
hyp2 = r.Hyperlinks(1).Address
End Function

--
Gary's Student


"Relic426" wrote:

> I have an excel application that queries a web site and downloads certain
> tables as html.. The tables contain hyperlinks, the location of which you
> can view if you mouse over them and by clicking on the cell, you can also
> follow these links.
>
> But what is actually displayed in the cell is the "friendly name". For
> future programming, I would like the actual link location displayed (either
> in these cells or different cells)... Does anyone know a way to do that?
>
> I've tried edit query, but excel vba learn doesn't record the link location??

 
Reply With Quote
 
Shailesh Shah
Guest
Posts: n/a
 
      28th Oct 2006
See VBA help for Hyperlink.

e.g. Range("A1").Hyperlinks(1).Address


Regards,
Shah Shailesh
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
 
=?Utf-8?B?UmVsaWM0MjY=?=
Guest
Posts: n/a
 
      28th Oct 2006
Thank you so much... works like a charm... I had no idea.

"Gary''s Student" wrote:

> Here is a one-liner:
>
> Function hyp2(r As Range) As String
> hyp2 = r.Hyperlinks(1).Address
> End Function
>
> --
> Gary's Student
>
>
> "Relic426" wrote:
>
> > I have an excel application that queries a web site and downloads certain
> > tables as html.. The tables contain hyperlinks, the location of which you
> > can view if you mouse over them and by clicking on the cell, you can also
> > follow these links.
> >
> > But what is actually displayed in the cell is the "friendly name". For
> > future programming, I would like the actual link location displayed (either
> > in these cells or different cells)... Does anyone know a way to do that?
> >
> > I've tried edit query, but excel vba learn doesn't record the link location??

 
Reply With Quote
 
=?Utf-8?B?R2FyeScncyBTdHVkZW50?=
Guest
Posts: n/a
 
      28th Oct 2006
You are very welcome.
--
Gary's Student


"Relic426" wrote:

> Thank you so much... works like a charm... I had no idea.
>
> "Gary''s Student" wrote:
>
> > Here is a one-liner:
> >
> > Function hyp2(r As Range) As String
> > hyp2 = r.Hyperlinks(1).Address
> > End Function
> >
> > --
> > Gary's Student
> >
> >
> > "Relic426" wrote:
> >
> > > I have an excel application that queries a web site and downloads certain
> > > tables as html.. The tables contain hyperlinks, the location of which you
> > > can view if you mouse over them and by clicking on the cell, you can also
> > > follow these links.
> > >
> > > But what is actually displayed in the cell is the "friendly name". For
> > > future programming, I would like the actual link location displayed (either
> > > in these cells or different cells)... Does anyone know a way to do that?
> > >
> > > I've tried edit query, but excel vba learn doesn't record the link location??

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink location Jillian Microsoft Frontpage 1 11th Sep 2009 07:19 AM
Hyperlink Link Field to link to file on website =?Utf-8?B?QlpleWdlcg==?= Microsoft Excel Programming 0 1st May 2007 05:06 PM
Inserting a hyperlink to file creates DFS hyperlink instead of drive-letter link Brian Roden Microsoft Outlook Discussion 0 18th Sep 2006 08:32 PM
Hyperlink to a location on worksheet and display full image. =?Utf-8?B?dHdpbGxpYW1z?= Microsoft Excel Misc 1 7th Feb 2006 10:06 PM
Re: extracting a hyperlink without the text link the hyperlink is in Tom Ogilvy Microsoft Excel Misc 0 8th Sep 2003 06:01 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:40 PM.