whatasks22
New Member
- Joined
- Jan 11, 2019
- Messages
- 5
Hey yall i keep getting the runtime error mentioned + Method "document" of object "IWebBrowser 2" failed. My code is pasted below this is a internal site so you wont be able to access it
Sub Assetgrabber()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate "http://spv-sccm-db01/Reports/Pages/Report.aspx?ItemPath=%2fConfigMgr_ORH%2fSoftware+-+Companies+and+Products%2fSoftware+registered+in+Add+Remove+Programs+on+a+specific+computer "
IE.Visible = True
While IE.Busy
DoEvents
Wend
IE.Document.All("ct131$ct104$ct103$txtValue") = ThisWorkbook.Sheets("sheet1").Range("a1")
End Sub
Sub Assetgrabber()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate "http://spv-sccm-db01/Reports/Pages/Report.aspx?ItemPath=%2fConfigMgr_ORH%2fSoftware+-+Companies+and+Products%2fSoftware+registered+in+Add+Remove+Programs+on+a+specific+computer "
IE.Visible = True
While IE.Busy
DoEvents
Wend
IE.Document.All("ct131$ct104$ct103$txtValue") = ThisWorkbook.Sheets("sheet1").Range("a1")
End Sub