| | |||||
| ||||||||
| Domain Newbies New to domain names? Have your questions answered here. |
![]() |
| | LinkBack | Thread Tools |
| | THREAD STARTER #1 (permalink) |
| NamePros Regular Join Date: Jun 2007
Posts: 883
![]() ![]() ![]() | Microsoft Excel guru (please help) Hi, I'm trying to figure out how to put automatic hyperlinks in some web addresses - so they automatically click through to the site. e.g.: www.robin.com www.happy.net www.bigboy.org I've been trying to figure it out and i have 1000 sites to check out and really don't want to have to type them all in. I've tried inserting a hyperlink, but it doesn't come through as a live link. Any help would be greatly appreciated. Thanks
__________________ Buy Domain Names – 9i.com, 3J.com, ZB.org, Foob.com, Wodo.com, Sixth.com – These are just a few of the great names on offer at namecake.com (Click below) Buy Domain Names Solar Garden Lights Virtual Reality Games |
| |
| | #2 (permalink) |
| Business Member Join Date: Mar 2008 Location: Australia
Posts: 4,201
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() | Are you referring to URL forwarding at the Domain Name Registrar? Not sure exactly what you are asking, if you supply more information that would be good. Cheers Corey
__________________ ☆ Occupy.TV website/domain name for sale! |
| |
| | #3 (permalink) |
| Senior Member Join Date: Jul 2005 Location: NJ
Posts: 1,219
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() | i think what he wants is a way to visit sites from a url in an excel file by just clicking... one trick would be to take an empty column, and use the following: Code: =HYPERLINK(A1,A1) ????: NamePros.com http://www.namepros.com/domain-newbies/499853-microsoft-excel-guru-please-help.html then just copy/paste that down (it should offer to fill in all of them if you just keep going down). it shoudl also automatically change A1 to A2, A3, A4, etc as you go down. then, you should be able to click those hyperlinks. does that help?
__________________ Hacksar.com - Your source for random computer tips and tricks! MySiteMemberships.com - Keep track of your site registration information! Like my post? Rep is appreciated! |
| |
| | #4 (permalink) |
| Domains my Dominion Join Date: Aug 2005 Location: Web 1.0
Posts: 9,552
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() | I assume you have a column of URLs as non-clickable text correct ? To convert the text to hyperlinks you could run a macro like this, assuming your range is "a1:a40" PHP Code:
__________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists |
| |
| | THREAD STARTER #6 (permalink) |
| NamePros Regular Join Date: Jun 2007
Posts: 883
![]() ![]() ![]() | Sorry for coming back late- been on holiday. The list i'm talking about has been merged - so no hyperlinks were created. Nasaboy - i tried what you suggested but didn't have any joy. Sdsinc- yes i have a column of url's as non clickable text - sadly i haven't got a clue how to apply the macro you have written.
__________________ Buy Domain Names – 9i.com, 3J.com, ZB.org, Foob.com, Wodo.com, Sixth.com – These are just a few of the great names on offer at namecake.com (Click below) Buy Domain Names Solar Garden Lights Virtual Reality Games |
| |
| | #7 (permalink) | ||||
| Domains my Dominion Join Date: Aug 2005 Location: Web 1.0
Posts: 9,552
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
????: NamePros.com http://www.namepros.com/showthread.php?t=499853 Again go to menu Tools -> Macro -> Macros, select the macro you've just recorded and click Edit. You will see a new window with code like this: Code: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8/12/2008 by ... ' ' End Sub You may have to change the range (here a1:a40) to fit your needs. Return to Excel. Use menu Tools -> Macro -> Macros, and click Run to execute the code. This should convert the URLs to clickable links.
__________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists | ||||
| |
| | THREAD STARTER #8 (permalink) |
| NamePros Regular Join Date: Jun 2007
Posts: 883
![]() ![]() ![]() | Thanks - i've tried it and still can't get it to work
__________________ Buy Domain Names – 9i.com, 3J.com, ZB.org, Foob.com, Wodo.com, Sixth.com – These are just a few of the great names on offer at namecake.com (Click below) Buy Domain Names Solar Garden Lights Virtual Reality Games |
| |