Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Send Key to open a particular internet browser | Excel Worksheet Functions | |||
Close an Internet Explorer browser window | Excel Programming | |||
Excel macro error when opened in internet browser | Excel Programming | |||
Passing a dataset from jsp to browser excel plugin | Excel Programming |