Receiving Script 70 error in ie11 every time i try to trigger a change event
up vote
0
down vote
favorite
Dim htl As MSHTML.HTMLDocument
'Start IE object
Set IE = CreateObject("InternetExplorer.Application")
'Go to Webpage
IE.Navigate VendorHome
'Sub that waits for the page to load
Call Load
'Create Event
Set htl = IE.document.createEvent("HTMLevents")
htl.initEvent "change", False, True
'Select the Dropdown box
SelectOpt.Click
'Select Option in Dropdown
For Each opt In SelectOpt
If opt.Text = "Purchase order number" Then
SelectOpt.ChildNodes(3).Selected = True
SelectOpt.Options(1).Selected = True
SelectOpt.selectedIndex = 1
' SelectOpt.dispatchEvent (htl) ' Error is Received on this Line
End If
Next
html excel vba triggers
asked Nov 11 at 5:10
P.Dow
11
|
show 2 more comments
up vote
0
down vote
favorite
Dim htl As MSHTML.HTMLDocument
'Start IE object
Set IE = CreateObject("InternetExplorer.Application")
'Go to Webpage
IE.Navigate VendorHome
'Sub that waits for the page to load
Call Load
'Create Event
Set htl = IE.document.createEvent("HTMLevents")
htl.initEvent "change", False, True
'Select the Dropdown box
SelectOpt.Click
'Select Option in Dropdown
For Each opt In SelectOpt
If opt.Text = "Purchase order number" Then
SelectOpt.ChildNodes(3).Selected = True
SelectOpt.Options(1).Selected = True
SelectOpt.selectedIndex = 1
' SelectOpt.dispatchEvent (htl) ' Error is Received on this Line
End If
Next
html excel vba triggers
asked Nov 11 at 5:10
P.Dow
11
welcome to SO, you did not mention what's the error
– Saeed Zhiany
Nov 11 at 5:16
You don't need the parentheses aroundhtlon the line which gives the error
– Tim Williams
Nov 11 at 5:20
Can you share the HTML/URL as there may be a better way.
– QHarr
Nov 11 at 5:35
The error I am receiving is SCRIPT70 - Permission Denied. I am unable to share the URL because this is for work.
– P.Dow
Nov 11 at 5:51
@TimWilliams I tried it without the parentheses, it still did not trigger the change event. Any more suggestions?
– P.Dow
Nov 11 at 5:55
|
show 2 more comments
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Dim htl As MSHTML.HTMLDocument
'Start IE object
Set IE = CreateObject("InternetExplorer.Application")
'Go to Webpage
IE.Navigate VendorHome
'Sub that waits for the page to load
Call Load
'Create Event
Set htl = IE.document.createEvent("HTMLevents")
htl.initEvent "change", False, True
'Select the Dropdown box
SelectOpt.Click
'Select Option in Dropdown
For Each opt In SelectOpt
If opt.Text = "Purchase order number" Then
SelectOpt.ChildNodes(3).Selected = True
SelectOpt.Options(1).Selected = True
SelectOpt.selectedIndex = 1
' SelectOpt.dispatchEvent (htl) ' Error is Received on this Line
End If
Next
html excel vba triggers
asked Nov 11 at 5:10
P.Dow
11
Dim htl As MSHTML.HTMLDocument
'Start IE object
Set IE = CreateObject("InternetExplorer.Application")
'Go to Webpage
IE.Navigate VendorHome
'Sub that waits for the page to load
Call Load
'Create Event
Set htl = IE.document.createEvent("HTMLevents")
htl.initEvent "change", False, True
'Select the Dropdown box
SelectOpt.Click
'Select Option in Dropdown
For Each opt In SelectOpt
If opt.Text = "Purchase order number" Then
SelectOpt.ChildNodes(3).Selected = True
SelectOpt.Options(1).Selected = True
SelectOpt.selectedIndex = 1
' SelectOpt.dispatchEvent (htl) ' Error is Received on this Line
End If
Next
html excel vba triggers
html excel vba triggers
asked Nov 11 at 5:10
P.Dow
11
asked Nov 11 at 5:10
P.Dow
11
asked Nov 11 at 5:10
P.Dow
11
asked Nov 11 at 5:10
P.Dow
11
asked Nov 11 at 5:10
P.Dow
11
11
welcome to SO, you did not mention what's the error
– Saeed Zhiany
Nov 11 at 5:16
You don't need the parentheses aroundhtlon the line which gives the error
– Tim Williams
Nov 11 at 5:20
Can you share the HTML/URL as there may be a better way.
– QHarr
Nov 11 at 5:35
The error I am receiving is SCRIPT70 - Permission Denied. I am unable to share the URL because this is for work.
– P.Dow
Nov 11 at 5:51
@TimWilliams I tried it without the parentheses, it still did not trigger the change event. Any more suggestions?
– P.Dow
Nov 11 at 5:55
|
show 2 more comments
welcome to SO, you did not mention what's the error
– Saeed Zhiany
Nov 11 at 5:16
You don't need the parentheses aroundhtlon the line which gives the error
– Tim Williams
Nov 11 at 5:20
Can you share the HTML/URL as there may be a better way.
– QHarr
Nov 11 at 5:35
The error I am receiving is SCRIPT70 - Permission Denied. I am unable to share the URL because this is for work.
– P.Dow
Nov 11 at 5:51
@TimWilliams I tried it without the parentheses, it still did not trigger the change event. Any more suggestions?
– P.Dow
Nov 11 at 5:55
welcome to SO, you did not mention what's the error
– Saeed Zhiany
Nov 11 at 5:16
welcome to SO, you did not mention what's the error
– Saeed Zhiany
Nov 11 at 5:16
You don't need the parentheses around
htl on the line which gives the error– Tim Williams
Nov 11 at 5:20
You don't need the parentheses around
htl on the line which gives the error– Tim Williams
Nov 11 at 5:20
Can you share the HTML/URL as there may be a better way.
– QHarr
Nov 11 at 5:35
Can you share the HTML/URL as there may be a better way.
– QHarr
Nov 11 at 5:35
The error I am receiving is SCRIPT70 - Permission Denied. I am unable to share the URL because this is for work.
– P.Dow
Nov 11 at 5:51
The error I am receiving is SCRIPT70 - Permission Denied. I am unable to share the URL because this is for work.
– P.Dow
Nov 11 at 5:51
@TimWilliams I tried it without the parentheses, it still did not trigger the change event. Any more suggestions?
– P.Dow
Nov 11 at 5:55
@TimWilliams I tried it without the parentheses, it still did not trigger the change event. Any more suggestions?
– P.Dow
Nov 11 at 5:55
|
show 2 more comments
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53246015%2freceiving-script-70-error-in-ie11-every-time-i-try-to-trigger-a-change-event%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
welcome to SO, you did not mention what's the error
– Saeed Zhiany
Nov 11 at 5:16
You don't need the parentheses around
htlon the line which gives the error– Tim Williams
Nov 11 at 5:20
Can you share the HTML/URL as there may be a better way.
– QHarr
Nov 11 at 5:35
The error I am receiving is SCRIPT70 - Permission Denied. I am unable to share the URL because this is for work.
– P.Dow
Nov 11 at 5:51
@TimWilliams I tried it without the parentheses, it still did not trigger the change event. Any more suggestions?
– P.Dow
Nov 11 at 5:55