How to use vba to open IE & then pull website of my choice

[aedctalk]

I have this code to open ie:

Call Shell("C:\Program Files\Internet Explorer\iexplore.exe", 1)

But how can i choose the site it loads?

Also.. what i wanted to do was pull a site that would be like

mysite.com?= MY CELL VALUE HERE

so mysite.com?=Configuration!J20

Is this possible? I would really really appreciate any insight

Thank you!!!!!!!!!!!

 

[aedctalk]

Ok. I have a sub that works..

Just curious how i could add a cell value to the end of this url?

Sub VisitWebsite()

Dim ie As Object
Set ie = CreateObject("INTERNETEXPLORER.[URL="http://www.xtremevbtalk.com/showthread.php?t=135256#"][COLOR=blue !important][FONT=verdana]APPLICATION[/FONT][/COLOR][/URL]")
ie.NAVIGATE "http://websiteaddress"
ie.Visible = True

While ie.busy
DoEvents
Wend

End Sub

Thank you so much!

 

[John_w]

Something like this:

ie.NAVIGATE "http://websiteaddress?param=" & Sheets("Configuration").Range("J20").Value

 

[aedctalk]

Thank you so much!

Worked like a charm. Very much appreciate the help