Runtime error '32' when trying to hover over one item to click a hidden button - Seleniumbasic / VBA
I'm trying to use Selenium in VBA to automatically click the expand button (bowtie) on a website - eventually to bring all that table data into excel.
I'm able to walk through every line of code and it's behaving correctly, except for this last line, when I try to select the hidden bowtie (maximize button in picture), I receive the Run-time error '32': Application-defined or object-defined error.
bot.FindElementByClass("richeditor-toolbar-button workitem-group-maximize").Click
I used the exact class provided when inspecting the bowtie - also tried a different class), but when I hit f8 - the session dies and the error pops up.
Any ideas what might be causing this?
Sub automation() Dim bot As New ChromeDriver, menuitem As WebElement
bot.Get "https://company.visualstudio.com/"
Set menuitem = bot.FindElementById("ui-id-38")
bot.Actions.MoveToElement(menuitem).Perform
bot.FindElementByClass("richeditor-toolbar-button workitem-group-maximize").Click
screenshot of inspected bowtie element
run time error screenshot
EDIT - played around a bit more and found that removing the last "div" from the class selector made it work. Adding screenshots of code for reference - this is an intranet site, so can't login without a company device - Screenshot 2 shows the inspected element I was trying to maximize.
I tried this version below as there were multiple versions of the bowtie on the page for other sections, removing the last div made it work.
This does not work because of the div at the end
bot.FindElementByCss("#vss_390 > div.tfs-collapsible-header.wit-form-group-header > button >div"
The below works since the div at the end was removed, though not sure why exactly
Set menuitem = bot.FindElementById("ui-id-38")
bot.Actions.MoveToElement(menuitem).Perform
bot.FindElementByCss("#vss_390 > div.tfs-collapsible-header.wit-form-group-header > button").Click
HTML Reference of page I was trying to work with HTML Reference
excel vba excel-vba selenium selenium-chromedriver
asked Dec 31 '18 at 23:34
Jiyaad NaeemJiyaad Naeem
12
add a comment |
I'm trying to use Selenium in VBA to automatically click the expand button (bowtie) on a website - eventually to bring all that table data into excel.
I'm able to walk through every line of code and it's behaving correctly, except for this last line, when I try to select the hidden bowtie (maximize button in picture), I receive the Run-time error '32': Application-defined or object-defined error.
bot.FindElementByClass("richeditor-toolbar-button workitem-group-maximize").Click
I used the exact class provided when inspecting the bowtie - also tried a different class), but when I hit f8 - the session dies and the error pops up.
Any ideas what might be causing this?
Sub automation() Dim bot As New ChromeDriver, menuitem As WebElement
bot.Get "https://company.visualstudio.com/"
Set menuitem = bot.FindElementById("ui-id-38")
bot.Actions.MoveToElement(menuitem).Perform
bot.FindElementByClass("richeditor-toolbar-button workitem-group-maximize").Click
screenshot of inspected bowtie element
run time error screenshot
EDIT - played around a bit more and found that removing the last "div" from the class selector made it work. Adding screenshots of code for reference - this is an intranet site, so can't login without a company device - Screenshot 2 shows the inspected element I was trying to maximize.
I tried this version below as there were multiple versions of the bowtie on the page for other sections, removing the last div made it work.
This does not work because of the div at the end
bot.FindElementByCss("#vss_390 > div.tfs-collapsible-header.wit-form-group-header > button >div"
The below works since the div at the end was removed, though not sure why exactly
Set menuitem = bot.FindElementById("ui-id-38")
bot.Actions.MoveToElement(menuitem).Perform
bot.FindElementByCss("#vss_390 > div.tfs-collapsible-header.wit-form-group-header > button").Click
HTML Reference of page I was trying to work with HTML Reference
excel vba excel-vba selenium selenium-chromedriver
asked Dec 31 '18 at 23:34
Jiyaad NaeemJiyaad Naeem
12
I get not authorized if I try to access page. Can you use the snippet tool to include the actual HTML.
– QHarr
Jan 1 at 0:20
Thank you QHarr ! Looked like all it needed was to remove a div at the end of the problem line as there were multiple instances of the bowtie on the page. Not sure why exactly that made it work, but if anyone knows, would love to better understand
– Jiyaad Naeem
Jan 1 at 5:35
add a comment |
I'm trying to use Selenium in VBA to automatically click the expand button (bowtie) on a website - eventually to bring all that table data into excel.
I'm able to walk through every line of code and it's behaving correctly, except for this last line, when I try to select the hidden bowtie (maximize button in picture), I receive the Run-time error '32': Application-defined or object-defined error.
bot.FindElementByClass("richeditor-toolbar-button workitem-group-maximize").Click
I used the exact class provided when inspecting the bowtie - also tried a different class), but when I hit f8 - the session dies and the error pops up.
Any ideas what might be causing this?
Sub automation() Dim bot As New ChromeDriver, menuitem As WebElement
bot.Get "https://company.visualstudio.com/"
Set menuitem = bot.FindElementById("ui-id-38")
bot.Actions.MoveToElement(menuitem).Perform
bot.FindElementByClass("richeditor-toolbar-button workitem-group-maximize").Click
screenshot of inspected bowtie element
run time error screenshot
EDIT - played around a bit more and found that removing the last "div" from the class selector made it work. Adding screenshots of code for reference - this is an intranet site, so can't login without a company device - Screenshot 2 shows the inspected element I was trying to maximize.
I tried this version below as there were multiple versions of the bowtie on the page for other sections, removing the last div made it work.
This does not work because of the div at the end
bot.FindElementByCss("#vss_390 > div.tfs-collapsible-header.wit-form-group-header > button >div"
The below works since the div at the end was removed, though not sure why exactly
Set menuitem = bot.FindElementById("ui-id-38")
bot.Actions.MoveToElement(menuitem).Perform
bot.FindElementByCss("#vss_390 > div.tfs-collapsible-header.wit-form-group-header > button").Click
HTML Reference of page I was trying to work with HTML Reference
excel vba excel-vba selenium selenium-chromedriver
asked Dec 31 '18 at 23:34
Jiyaad NaeemJiyaad Naeem
12
I'm trying to use Selenium in VBA to automatically click the expand button (bowtie) on a website - eventually to bring all that table data into excel.
I'm able to walk through every line of code and it's behaving correctly, except for this last line, when I try to select the hidden bowtie (maximize button in picture), I receive the Run-time error '32': Application-defined or object-defined error.
bot.FindElementByClass("richeditor-toolbar-button workitem-group-maximize").Click
I used the exact class provided when inspecting the bowtie - also tried a different class), but when I hit f8 - the session dies and the error pops up.
Any ideas what might be causing this?
Sub automation() Dim bot As New ChromeDriver, menuitem As WebElement
bot.Get "https://company.visualstudio.com/"
Set menuitem = bot.FindElementById("ui-id-38")
bot.Actions.MoveToElement(menuitem).Perform
bot.FindElementByClass("richeditor-toolbar-button workitem-group-maximize").Click
screenshot of inspected bowtie element
run time error screenshot
EDIT - played around a bit more and found that removing the last "div" from the class selector made it work. Adding screenshots of code for reference - this is an intranet site, so can't login without a company device - Screenshot 2 shows the inspected element I was trying to maximize.
I tried this version below as there were multiple versions of the bowtie on the page for other sections, removing the last div made it work.
This does not work because of the div at the end
bot.FindElementByCss("#vss_390 > div.tfs-collapsible-header.wit-form-group-header > button >div"
The below works since the div at the end was removed, though not sure why exactly
Set menuitem = bot.FindElementById("ui-id-38")
bot.Actions.MoveToElement(menuitem).Perform
bot.FindElementByCss("#vss_390 > div.tfs-collapsible-header.wit-form-group-header > button").Click
HTML Reference of page I was trying to work with HTML Reference
excel vba excel-vba selenium selenium-chromedriver
excel vba excel-vba selenium selenium-chromedriver
asked Dec 31 '18 at 23:34
Jiyaad NaeemJiyaad Naeem
12
asked Dec 31 '18 at 23:34
Jiyaad NaeemJiyaad Naeem
12
edited Jan 1 at 5:33
Jiyaad Naeem
asked Dec 31 '18 at 23:34
Jiyaad NaeemJiyaad Naeem
12
asked Dec 31 '18 at 23:34
Jiyaad NaeemJiyaad Naeem
12
asked Dec 31 '18 at 23:34
Jiyaad NaeemJiyaad Naeem
12
12
I get not authorized if I try to access page. Can you use the snippet tool to include the actual HTML.
– QHarr
Jan 1 at 0:20
Thank you QHarr ! Looked like all it needed was to remove a div at the end of the problem line as there were multiple instances of the bowtie on the page. Not sure why exactly that made it work, but if anyone knows, would love to better understand
– Jiyaad Naeem
Jan 1 at 5:35
add a comment |
I get not authorized if I try to access page. Can you use the snippet tool to include the actual HTML.
– QHarr
Jan 1 at 0:20
Thank you QHarr ! Looked like all it needed was to remove a div at the end of the problem line as there were multiple instances of the bowtie on the page. Not sure why exactly that made it work, but if anyone knows, would love to better understand
– Jiyaad Naeem
Jan 1 at 5:35
I get not authorized if I try to access page. Can you use the snippet tool to include the actual HTML.
– QHarr
Jan 1 at 0:20
I get not authorized if I try to access page. Can you use the snippet tool to include the actual HTML.
– QHarr
Jan 1 at 0:20
Thank you QHarr ! Looked like all it needed was to remove a div at the end of the problem line as there were multiple instances of the bowtie on the page. Not sure why exactly that made it work, but if anyone knows, would love to better understand
– Jiyaad Naeem
Jan 1 at 5:35
Thank you QHarr ! Looked like all it needed was to remove a div at the end of the problem line as there were multiple instances of the bowtie on the page. Not sure why exactly that made it work, but if anyone knows, would love to better understand
– Jiyaad Naeem
Jan 1 at 5:35
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
});
}
});
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%2f53992138%2fruntime-error-32-when-trying-to-hover-over-one-item-to-click-a-hidden-button%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
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.
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%2f53992138%2fruntime-error-32-when-trying-to-hover-over-one-item-to-click-a-hidden-button%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
I get not authorized if I try to access page. Can you use the snippet tool to include the actual HTML.
– QHarr
Jan 1 at 0:20
Thank you QHarr ! Looked like all it needed was to remove a div at the end of the problem line as there were multiple instances of the bowtie on the page. Not sure why exactly that made it work, but if anyone knows, would love to better understand
– Jiyaad Naeem
Jan 1 at 5:35