Pull URL from IE to store as Variable in Excel

Hi everyone I am getting stuck on a program I am writing at work.

What I'm attempting to do: I have an excel sheet program, this excel program will open IE and navigate to a website (newegg for example) when the website loads, it will insert a stored variable from the excel sheet into the search field of the website (sony battery for example). Once the new page loads, the URL of the new page is then stored as a variable.

Is this even possible to do with VBA?

any help is much appreciated

here is what I have so far: New IE window opens and is directed to the site

Sub VisitWebsite()

Dim ie As Object
Set ie = CreateObject("INTERNETEXPLORER.APPLICATION")
ie.NAVIGATE "http://www.newegg.com"
ie.Visible = True

While ie.busy
DoEvents
Wend

End Sub

odo-