How to paste TARGET of a hyperlink?

September 28, 2008 at 22:53:59
Specs: XP, Athlon XP
I'm trying to paste the target of a hyperlink from a website into Word or excel. It's proving to be very difficult.

When I copy the hyperlink from the website, it's the hyperlink itself that is pasted. The target information is attached, and I can follow (& open) the target in both Word & Excel, but I would like to just paste the target info itself instead of opening the target.

I would greatly apreciate any help.

Thanx


See More: How to paste TARGET of a hyperlink?

Report •


#1
September 28, 2008 at 23:23:53
If you right click on a hyperlink (such as those on the left), you will be presented with a menu. Select "Copy shortcut" and the URL of the page you would be taken to had you clicked the link will be copied to the clipboard. Then paste this in Word/Excel.

-Ryan Adams
Free Computer Tips and more:http://RyanTAdams.com

Paid Tech Support: Black Diamond


Report •

#2
September 28, 2008 at 23:58:45
Thanks for your help. I'm aware of that, and it will work, but...

My problem lies in that I'm copying a list of almost 200 objects, but the copy shortcut option will only copy one at a time, even if many are selected.

I can copy and paste all of the objects, which are all hyperlinks, then I could even edit the hyperlink, copy & paste.

But I'm afraid of carpel tunnel...


Report •

#3
September 29, 2008 at 00:05:17
Oh, I think I see what you are getting at. Could you post a link to the page with these hyperlinks so I can see how they are formatted.

-Ryan Adams
Free Computer Tips and more:http://RyanTAdams.com

Paid Tech Support: Black Diamond


Report •

Related Solutions

#4
September 29, 2008 at 00:13:11
It's kind of sensitive, so I'll PM you

Report •

#5
September 29, 2008 at 08:17:22
This should help you see the light at the end of your carpel tunnel:

Paste your links as HTML into a spreadsheet, select them and run this code. It should put the URL for each link in the next column. It worked with the links in the left hand column of this website.


Sub HyperLinkAddress()
On Error Resume Next
For Each hLink In Selection
Range(hLink.Address).Offset(0, 1) = hLink.Hyperlinks(1).Address
Next
End Sub


Report •

#6
September 29, 2008 at 09:34:11
Brilliant!

That did the trick. Thanks very much, everyone!


Report •

#7
October 30, 2008 at 03:42:26
You can view this programs - bookmarks managers for organise, sychronize your bookmarks between any browsers or computers.
In the new version they promised export of links in Excel. Probably it will be interesting to you.

Report •


Ask Question