I am able to open an instance of Internet Explorer but seem to have forgotten how to place a url into the address bar and how to sendkeys.
my sendkeys seems to be getting lost and not sending to explorer.
I'm using

Dim retval
retval = Shell("C:\Program Files\Internet Explorer\iexplore.exe")
SendKeys "{tab}{c}"


how can I put this url into the address bar?
http://www.access-programmers.co.uk/forums/forumdisplay.php?f=55

smiler44

I am able to open an instance of Internet Explorer but seem to have forgotten how to place a url into the address bar and how to sendkeys.
my sendkeys seems to be getting lost and not sending to explorer.
I'm using

Dim retval
retval = Shell("C:\Program Files\Internet Explorer\iexplore.exe")
SendKeys "{tab}{c}"


how can I put this url into the address bar?
http://www.access-programmers.co.uk/forums/forumdisplay.php?f=55

smiler44

use NAVIGATE:ie.navigate URL HERE AS A STRING

Adam,
I think I have misunderstood. I get a run time error 424 object required

what should the code look like, mine must be wrong.
smiler44

Adam,
I think I have misunderstood. I get a run time error 424 object required

what should the code look like, mine must be wrong.
smiler44

post your code that you're using first to manipulate IE through VBA. post it all

Adam,
thanks to you I may have found what I need. A search on Google using Navigate gave me this which seems to work.


Set IE = CreateObject("InternetExplorer.Application")
With IE
.navigate "url goes here"
.Visible = True
End With
Set IE = Nothing


or what's below. I'm not sure if what is below is better as I'm unsure if it is checking to make sure internet explorer has loaded


Dim URL As String
Dim IE As Object

URL = "url goes here"

Set IE = CreateObject("InternetExplorer.Application")

With IE
.Visible = True
.navigate URL
Do While .Busy Or .readyState <> 4: DoEvents: Loop
End With



smiler44

it's also explained in wayyyyyyy too much detail HERE: http://www.access-programmers.co.uk/forums/showthread.php?t=176968 :D

glad you got it sorted. :)