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