Hi SyrNO,

Could you post the full code?

I am very interested in passing data to IE.

Many thanks,

Antonio

"SyrNO" wrote:

I got it. Was checking out www.ozgrid.com and found the following bit of
code that basically says, "until the browser is ready, busy yourself". THEN,
I am able to use SENDKEYS to move to the necessary textboxes and send the
variable data.

Set ie = CreateObject("InternetExplorer.Application")

ie.navigate "https://www.anywhere.com"
Do While ie.busy And Not ie.readystate = 4
DoEvents
Loop

ie.Visible = True

works like a charm :-))


"SyrNO" wrote:

I'm trying to write code that will assign data in 3 cells to 3 variables,
i.e. -
strVIN = activecell.offset(0,-3).value
strDate = activecell.offset(0,-2).value
strName = activecell.offset(0,-1).value

Then, I want to open an Internet Browser window (user's default browser),
navigate to a specific website (I have this part down), and then place the
values of my 3 variables into 3 text boxes on the website.

I tried SendKeys using the Tab key and then the variables. Problem with
this is the timing of the action. If the browser window doesn't open soon
enough, the data is pasted in the active cell in Excel.

How can I consistently paste the information in the proper browser locations
every time?