G
Guest
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?
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?