Well you can't with the way your going about it Excell VBA can interface with
some windows applications but I don't think that it was ment to the way your
trying to do it seem's like the hard way.

I would suggest using VBS (Visual Basic Script) in conjunction with you
Excell to accomplish this. Although if you are not firmilar with VBS this
could poise a problem.

Unfortuanitly I am not firmillar enough with VBS to show you how to do this
with a code example.


"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?