Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Open Multiple Hyperlinks at once in Excel 2003????


(!)

Wolverine-Eric's Avatar
Wolverine-Eric Wolverine-Eric is offline
Junior Member with 10 posts.
THREAD STARTER
 
Join Date: May 2007
Experience: Knows enough to be dangerous!
17-Feb-2010, 05:44 PM #1
Open Multiple Hyperlinks at once in Excel 2003????
Hi Guys,

I tried to search for an answer to this prior to posting. I did not see one.

I have a much larger version of the following sheet. All of the website links are hyperlinks. How can I open all of them at once?



Thanks for taking the time to answer!

Eric
Wolverine-Eric's Avatar
Wolverine-Eric Wolverine-Eric is offline
Junior Member with 10 posts.
THREAD STARTER
 
Join Date: May 2007
Experience: Knows enough to be dangerous!
23-Feb-2010, 04:31 PM #2
Anybody? Anybody?

Bueller... Bueller... Bueller
Rollin_Again's Avatar
Member with 4,693 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
23-Feb-2010, 05:16 PM #3
Why exactly are you doing this? Should each site open in it's own Internet Explorer Window?

Regards,
Rollin
Wolverine-Eric's Avatar
Wolverine-Eric Wolverine-Eric is offline
Junior Member with 10 posts.
THREAD STARTER
 
Join Date: May 2007
Experience: Knows enough to be dangerous!
23-Feb-2010, 05:31 PM #4
Quote:
Why exactly are you doing this? Should each site open in it's own Internet Explorer Window?

Regards,
Rollin
Thanks for the reply Rollin.

I have LOTS of websites that I need to review. It will save a good bit of time if I can just highlight a bunch of cell and open all of the hyperlinks in them. I don't really care if they open as tabs or if each has it's own window. I'm just looking for a way to save time.
Rollin_Again's Avatar
Member with 4,693 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
23-Feb-2010, 05:51 PM #5
Use the code below. It assumes the first URL in the list appears in cell A2.

Code:
Sub OpenLinks()

For Each vCell In Range("A2:A" & Cells(Rows.Count, "A").End(xlUp).Row)
Set oIE = CreateObject("InternetExplorer.Application")
oIE.Visible = True
oIE.Navigate (vCell.Value)
Next vCell

End Sub
If you prefer to manually highlight the range to use just replace the second line of code so that it reads

Code:
For Each vCell In Selection

Regards,
Rollin
Wolverine-Eric's Avatar
Wolverine-Eric Wolverine-Eric is offline
Junior Member with 10 posts.
THREAD STARTER
 
Join Date: May 2007
Experience: Knows enough to be dangerous!
23-Feb-2010, 06:10 PM #6
Awesome! Thanks!

Now, I've changed my mind about all of those open windows... Is there a way to do this in one window with each one opening in it's own tab?
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
23-Feb-2010, 06:44 PM #7
This code isn't as slick, I am sure, but I found all this on this page:
http://www.codeproject.com/Messages/...7-using-V.aspx

Code:
Public Sub goNav()
Dim ie as Object

Set IE = CreateObject("InternetExplorer.Application")
ie.visible = true

Dim x as integer
Dim links as Hyperlinks
Set links = ActiveSheet.Hyperlinks

For x = 1 to links.count
ie.navigate links.item(x).address,nothing, "_blank"
next

End Sub

For it to open in new tabs this setting must be set in IE settings;
Internet Options
General Tab
Tabs Settings : Settings
Always open pop-ups in a new tab = Selected
Rollin_Again's Avatar
Member with 4,693 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
23-Feb-2010, 06:50 PM #8
Try this instead

Code:
Sub OpenLinks()

Const navOpenInNewTab = &H800
Set oIE = CreateObject("InternetExplorer.Application")
oIE.Visible = True

For Each vCell In Selection
oIE.Navigate vCell.Value, CLng(navOpenInNewTab)
Next vCell

End Sub
Regards,
Rollin
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
23-Feb-2010, 07:40 PM #9
LOL! I knew you would come up with something better, Rollin!
Wolverine-Eric's Avatar
Wolverine-Eric Wolverine-Eric is offline
Junior Member with 10 posts.
THREAD STARTER
 
Join Date: May 2007
Experience: Knows enough to be dangerous!
23-Feb-2010, 11:28 PM #10
Curious... how would I do the same thing in Mozilla?

Am I wearing out my welcome yet? hope not...

Guys... I really appreciate the help. I wish that I knew Excel better. I'm learnin'
Rollin_Again's Avatar
Member with 4,693 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
24-Feb-2010, 02:01 PM #11
Sorry I'm not sure how to do it in Mozilla Firefox. You could likely use a shell execute command and pass the URL as an argument but if you use Mozilla I'm pretty sure you'll have to open a separate Window for each site.

Rollin
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
24-Feb-2010, 03:24 PM #12
Firefox.

You can add the Web Page Preview button to one of your Excel toolbars, then click it.

Once this has opened the list in a new FireFox tab, CTRL+A to Select All, then: rightclick - S - Enter.
Wolverine-Eric's Avatar
Wolverine-Eric Wolverine-Eric is offline
Junior Member with 10 posts.
THREAD STARTER
 
Join Date: May 2007
Experience: Knows enough to be dangerous!
24-Feb-2010, 06:40 PM #13
Quote:
Firefox.

You can add the Web Page Preview button to one of your Excel toolbars, then click it.

Once this has opened the list in a new FireFox tab, CTRL+A to Select All, then: rightclick - S - Enter.
Thanks... but this does not work
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
24-Feb-2010, 07:03 PM #14
Since opening up the Excel calls on a shell command - just as it does for IE - I don't think this is possible.
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
24-Feb-2010, 07:21 PM #15
Quote:
Originally Posted by Wolverine-Eric
Thanks... but this does not work
Works fine for me. Which part doesn't for you?
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑