VBA for Opening Multiple IE and go to specific HTTP in cell

[jalifid11]

I've got to do maintenance on several HTTP addresses.

I've got 10 HTTP addresses in cells A1:A10.

What is a good VBA that will open up 10 IE and go to each of the HTTP addresses in A1:A10?

 

[poolhall]

Try this:

Sub Test
Dim myRange as Range, c as Range
Dim oShell as Object

Set myRange = sheet1.Range("A1:A10")
Set oShell = CreateObject("Wscript.Shell")

For each c in myRange
       oShell.Run c
Next c

End Sub

 

[jalifid11]

Thanks poolhall..

When I attempt to run the macro, I get an error...

it can't run the oShell.Run c

 

[poolhall]

it runs fine in my Excel, 2003 and 2007. What's exact error are you getting? Also, give me the example of value in A1.

 

[jalifid11]

when I run the macro, I get a "Run-time error '5': Invalid procedure or argument" error... and it highlights the oShell.Run c line.

I used the http address to this post as an example in A1.

http://www.mrexcel.com/forum/showth...g-Multiple-IE-and-go-to-specific-HTTP-in-cell

 

[poolhall]

it's probably the reference error.

Sheet1 in

Set myRange = Sheet1.Range("A1:A1")

refers to a worksheet with a code name Sheet1. It does not refer to a worksheet named Sheet1.
Please change it to the correct codename, or use a worksheet name

Set myRange = Sheets("Sheet1").Range("A1:A10")

or use it like this:

Set myRange = ActiveSheet.Range("A1:A10")