PDA

View Full Version : Pass value from excel to IE form


clif
05-04-2015, 12:23 AM
Sub Macro()

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")

IE.navigate "http://abc.aspx"
IE.Visible = True
While IE.Busy
DoEvents
Wend
IE.document.all("Name").Value = ThisWorkbook.Sheets("sheet1").Range("a1")

End sub



There is error shown in attached docx.
How can i solve it? Thanks!
clif
05-04-2015, 08:05 AM
Sub Macro()

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")

IE.navigate "http://abc.aspx"
IE.Visible = True
While IE.Busy
DoEvents
Wend
IE.document.all("Name").Value = ThisWorkbook.Sheets("sheet1").Range("a1")

End sub



There is error shown in attached docx.
How can i solve it? Thanks!

Can anyone help？