Automate pressing “Buttons” on web pages
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
Can someone help please, i can't seem to get the below to work
Sub Automate_IE_Load_Page()
'This will load a webpage in IE
Dim i As Long
Dim URL As String
Dim IE As InternetExplorer
Dim objElement As Object
Dim objCollection As Object
'Create InternetExplorer Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
URL = "https://Whatever" 'Not putting the URL up here
IE.Navigate URL
Do Until IE.ReadyState = 4: DoEvents: Loop
IE.Document.getElementbyid("menuoptionCell_Excel2007+").Click '(Fails here)
'Set Button = IE.Document.getElementbyid("menuoptionCell_Excel2007+")
'Button.Click
End Sub
i have also tried
IE.Document.getElementsbyClass("contextMenuOptionTextCell")(0).Click
It is saying i need an object. I have tried different methods but none seem to work. I will say i am using the word "Button" loosely as its not actually a button, but not sure what it is called. Below are the identities used on the web page, and i'm not totally sure which i need to press, but neither seem to work
<td class="contextMenuOptionTextCell">
<span class="contextMenuOptionText">Excel 2007+</span></td>
<td id="menuoptionCell_Excel2007+" style="vertical-align: top; width: 16px;"></td>
thank you
Mike
vba internet-explorer getelementbyid getelementsbyclassname
asked Nov 16 '18 at 16:58
Mike HillMike Hill
488
add a comment |
0
Can someone help please, i can't seem to get the below to work
Sub Automate_IE_Load_Page()
'This will load a webpage in IE
Dim i As Long
Dim URL As String
Dim IE As InternetExplorer
Dim objElement As Object
Dim objCollection As Object
'Create InternetExplorer Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
URL = "https://Whatever" 'Not putting the URL up here
IE.Navigate URL
Do Until IE.ReadyState = 4: DoEvents: Loop
IE.Document.getElementbyid("menuoptionCell_Excel2007+").Click '(Fails here)
'Set Button = IE.Document.getElementbyid("menuoptionCell_Excel2007+")
'Button.Click
End Sub
i have also tried
IE.Document.getElementsbyClass("contextMenuOptionTextCell")(0).Click
It is saying i need an object. I have tried different methods but none seem to work. I will say i am using the word "Button" loosely as its not actually a button, but not sure what it is called. Below are the identities used on the web page, and i'm not totally sure which i need to press, but neither seem to work
<td class="contextMenuOptionTextCell">
<span class="contextMenuOptionText">Excel 2007+</span></td>
<td id="menuoptionCell_Excel2007+" style="vertical-align: top; width: 16px;"></td>
thank you
Mike
vba internet-explorer getelementbyid getelementsbyclassname
asked Nov 16 '18 at 16:58
Mike HillMike Hill
488
As a minimum have While ie .Busy Or ie.readyState < 4: DoEvents: Wend to allow for page load. And consider a timed loop to attempt to set a reference to the object
– QHarr
Nov 16 '18 at 17:34
Can you verify thatIE.Document.getElementsbyClass("contextMenuOptionTextCell")(0)orgetElementbyid("menuoptionCell_Excel2007+")actually returns an object?
– siggi_pop
Nov 16 '18 at 19:30
You are trying to click TD tag. If you click on TD tag by mouse then nothing happen. I suggest you to create a HTML button inside your TD tag and than try to click the button.
– Deepak-MSFT
Nov 19 '18 at 3:06
Thanks guys, this isnt a web page i have built, i'm trying to learn how to automate web activity, basically trying to automate the extraction of reports with out an API. I'm not that clued up on it, so don't really know where to start, but on researching the web this is what i have found, or variants of this, and i cant get this to work.
– Mike Hill
Nov 21 '18 at 11:05
add a comment |
0
0
0
Can someone help please, i can't seem to get the below to work
Sub Automate_IE_Load_Page()
'This will load a webpage in IE
Dim i As Long
Dim URL As String
Dim IE As InternetExplorer
Dim objElement As Object
Dim objCollection As Object
'Create InternetExplorer Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
URL = "https://Whatever" 'Not putting the URL up here
IE.Navigate URL
Do Until IE.ReadyState = 4: DoEvents: Loop
IE.Document.getElementbyid("menuoptionCell_Excel2007+").Click '(Fails here)
'Set Button = IE.Document.getElementbyid("menuoptionCell_Excel2007+")
'Button.Click
End Sub
i have also tried
IE.Document.getElementsbyClass("contextMenuOptionTextCell")(0).Click
It is saying i need an object. I have tried different methods but none seem to work. I will say i am using the word "Button" loosely as its not actually a button, but not sure what it is called. Below are the identities used on the web page, and i'm not totally sure which i need to press, but neither seem to work
<td class="contextMenuOptionTextCell">
<span class="contextMenuOptionText">Excel 2007+</span></td>
<td id="menuoptionCell_Excel2007+" style="vertical-align: top; width: 16px;"></td>
thank you
Mike
vba internet-explorer getelementbyid getelementsbyclassname
asked Nov 16 '18 at 16:58
Mike HillMike Hill
488
Can someone help please, i can't seem to get the below to work
Sub Automate_IE_Load_Page()
'This will load a webpage in IE
Dim i As Long
Dim URL As String
Dim IE As InternetExplorer
Dim objElement As Object
Dim objCollection As Object
'Create InternetExplorer Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
URL = "https://Whatever" 'Not putting the URL up here
IE.Navigate URL
Do Until IE.ReadyState = 4: DoEvents: Loop
IE.Document.getElementbyid("menuoptionCell_Excel2007+").Click '(Fails here)
'Set Button = IE.Document.getElementbyid("menuoptionCell_Excel2007+")
'Button.Click
End Sub
i have also tried
IE.Document.getElementsbyClass("contextMenuOptionTextCell")(0).Click
It is saying i need an object. I have tried different methods but none seem to work. I will say i am using the word "Button" loosely as its not actually a button, but not sure what it is called. Below are the identities used on the web page, and i'm not totally sure which i need to press, but neither seem to work
<td class="contextMenuOptionTextCell">
<span class="contextMenuOptionText">Excel 2007+</span></td>
<td id="menuoptionCell_Excel2007+" style="vertical-align: top; width: 16px;"></td>
thank you
Mike
vba internet-explorer getelementbyid getelementsbyclassname
vba internet-explorer getelementbyid getelementsbyclassname
asked Nov 16 '18 at 16:58
Mike HillMike Hill
488
asked Nov 16 '18 at 16:58
Mike HillMike Hill
488
asked Nov 16 '18 at 16:58
Mike HillMike Hill
488
asked Nov 16 '18 at 16:58
Mike HillMike Hill
488
asked Nov 16 '18 at 16:58
Mike HillMike Hill
488
488
As a minimum have While ie .Busy Or ie.readyState < 4: DoEvents: Wend to allow for page load. And consider a timed loop to attempt to set a reference to the object
– QHarr
Nov 16 '18 at 17:34
Can you verify thatIE.Document.getElementsbyClass("contextMenuOptionTextCell")(0)orgetElementbyid("menuoptionCell_Excel2007+")actually returns an object?
– siggi_pop
Nov 16 '18 at 19:30
You are trying to click TD tag. If you click on TD tag by mouse then nothing happen. I suggest you to create a HTML button inside your TD tag and than try to click the button.
– Deepak-MSFT
Nov 19 '18 at 3:06
Thanks guys, this isnt a web page i have built, i'm trying to learn how to automate web activity, basically trying to automate the extraction of reports with out an API. I'm not that clued up on it, so don't really know where to start, but on researching the web this is what i have found, or variants of this, and i cant get this to work.
– Mike Hill
Nov 21 '18 at 11:05
add a comment |
As a minimum have While ie .Busy Or ie.readyState < 4: DoEvents: Wend to allow for page load. And consider a timed loop to attempt to set a reference to the object
– QHarr
Nov 16 '18 at 17:34
Can you verify thatIE.Document.getElementsbyClass("contextMenuOptionTextCell")(0)orgetElementbyid("menuoptionCell_Excel2007+")actually returns an object?
– siggi_pop
Nov 16 '18 at 19:30
You are trying to click TD tag. If you click on TD tag by mouse then nothing happen. I suggest you to create a HTML button inside your TD tag and than try to click the button.
– Deepak-MSFT
Nov 19 '18 at 3:06
Thanks guys, this isnt a web page i have built, i'm trying to learn how to automate web activity, basically trying to automate the extraction of reports with out an API. I'm not that clued up on it, so don't really know where to start, but on researching the web this is what i have found, or variants of this, and i cant get this to work.
– Mike Hill
Nov 21 '18 at 11:05
As a minimum have While ie .Busy Or ie.readyState < 4: DoEvents: Wend to allow for page load. And consider a timed loop to attempt to set a reference to the object
– QHarr
Nov 16 '18 at 17:34
As a minimum have While ie .Busy Or ie.readyState < 4: DoEvents: Wend to allow for page load. And consider a timed loop to attempt to set a reference to the object
– QHarr
Nov 16 '18 at 17:34
Can you verify that
IE.Document.getElementsbyClass("contextMenuOptionTextCell")(0) or getElementbyid("menuoptionCell_Excel2007+") actually returns an object?– siggi_pop
Nov 16 '18 at 19:30
Can you verify that
IE.Document.getElementsbyClass("contextMenuOptionTextCell")(0) or getElementbyid("menuoptionCell_Excel2007+") actually returns an object?– siggi_pop
Nov 16 '18 at 19:30
You are trying to click TD tag. If you click on TD tag by mouse then nothing happen. I suggest you to create a HTML button inside your TD tag and than try to click the button.
– Deepak-MSFT
Nov 19 '18 at 3:06
You are trying to click TD tag. If you click on TD tag by mouse then nothing happen. I suggest you to create a HTML button inside your TD tag and than try to click the button.
– Deepak-MSFT
Nov 19 '18 at 3:06
Thanks guys, this isnt a web page i have built, i'm trying to learn how to automate web activity, basically trying to automate the extraction of reports with out an API. I'm not that clued up on it, so don't really know where to start, but on researching the web this is what i have found, or variants of this, and i cant get this to work.
– Mike Hill
Nov 21 '18 at 11:05
Thanks guys, this isnt a web page i have built, i'm trying to learn how to automate web activity, basically trying to automate the extraction of reports with out an API. I'm not that clued up on it, so don't really know where to start, but on researching the web this is what i have found, or variants of this, and i cant get this to work.
– Mike Hill
Nov 21 '18 at 11:05
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2f53342301%2fautomate-pressing-buttons-on-web-pages%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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%2f53342301%2fautomate-pressing-buttons-on-web-pages%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
As a minimum have While ie .Busy Or ie.readyState < 4: DoEvents: Wend to allow for page load. And consider a timed loop to attempt to set a reference to the object
– QHarr
Nov 16 '18 at 17:34
Can you verify that
IE.Document.getElementsbyClass("contextMenuOptionTextCell")(0)orgetElementbyid("menuoptionCell_Excel2007+")actually returns an object?– siggi_pop
Nov 16 '18 at 19:30
You are trying to click TD tag. If you click on TD tag by mouse then nothing happen. I suggest you to create a HTML button inside your TD tag and than try to click the button.
– Deepak-MSFT
Nov 19 '18 at 3:06
Thanks guys, this isnt a web page i have built, i'm trying to learn how to automate web activity, basically trying to automate the extraction of reports with out an API. I'm not that clued up on it, so don't really know where to start, but on researching the web this is what i have found, or variants of this, and i cant get this to work.
– Mike Hill
Nov 21 '18 at 11:05