Mandla Sibanda
Programmer
Hi Team
Kindly assist in the below. The code serves to load a webpage and input values from a spreadsheet. I have been using it for over 3 years with no problem. The issue started when we upgraded to IE 11...objIE.Document AND getElementByID are no longer recognized. Please assist as I am now doing this process manually and takes up much of my time. See below:
Set objIE = CreateObject("InternetExplorer.Application")
set WshShell = WScript.CreateObject("WScript.Shell")
objIE.Visible = True
objIE.FullScreen=True
objIE.Navigate "
If jobname = "BO_VL_Offline" Then
With objIE.Document
.getElementByID("ctl00_MainContent_otGridView_ctl05_ot_Offline_Actual").value = oojobtimex
end with
End If
Kindly assist in the below. The code serves to load a webpage and input values from a spreadsheet. I have been using it for over 3 years with no problem. The issue started when we upgraded to IE 11...objIE.Document AND getElementByID are no longer recognized. Please assist as I am now doing this process manually and takes up much of my time. See below:
Set objIE = CreateObject("InternetExplorer.Application")
set WshShell = WScript.CreateObject("WScript.Shell")
objIE.Visible = True
objIE.FullScreen=True
objIE.Navigate "
If jobname = "BO_VL_Offline" Then
With objIE.Document
.getElementByID("ctl00_MainContent_otGridView_ctl05_ot_Offline_Actual").value = oojobtimex
end with
End If