ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Trouble with SENDKEYS? (https://www.excelbanter.com/excel-programming/387075-trouble-sendkeys.html)

DW

Trouble with SENDKEYS?
 
Under XL 2003, I created a macro to open and navigate thru a web page using
ie6. Now, under XL 2007 (Standard), part of the macro works but the
inserting of data into fields does not. Any suggestions?

Set ie = CreateObject("InternetExplorer.Application")
With ie
.Visible = True
.navigate "http://www.smcorp.com"
.resizable = True
End With
Application.Wait (Now + TimeValue("0:00:05"))
SendKeys "MY DATA"
SendKeys "{TAB}"

Don




All times are GMT +1. The time now is 01:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com