Posts by Daniel Aristofanes • 73 points
17 posts
-
0
votes0
answers1999
viewsQ: how to click the "ok" button on an Internet Explorer alert using VBA?
Hello, I have a VBA code that accesses a web page and deletes the entries. The moment I click the button "delete item" opens an alert on the screen with two buttons ("okay" and "Cancel") and…
-
0
votes1
answer3999
viewsA: how do VBA interact with more than one tab in Internet Explorer?
Got it! the following code goes from tab to tab of IE and tests if the desired element is on the page and if the URL is equal to the desired sub x() CapturaTela (irpNr) end sub Public Sub…
-
0
votes1
answer3999
viewsQ: how do VBA interact with more than one tab in Internet Explorer?
I have a macro in VBA that handles Internet Explorer, at certain point when clicking an item, a new tab opens in Internet Explorer. My doubt is: how to change the focus of VBA to manipulate this new…
-
1
votes1
answer480
viewsA: VBA: the underlying connection was closed: unexpected error on a receipt
After much research I found the solution! The error was happening because Chrome had upgraded to the latest version and the Chromedriver I was using did not support this version of Chrome. I…
-
1
votes1
answer480
viewsQ: VBA: the underlying connection was closed: unexpected error on a receipt
I have a VBA project that interacts with web pages using the Seleniumwrapper reference. In Windows vista business the application works normally, however, in Windows 7 appears the error reported in…
-
0
votes1
answer333
viewsA: access menu with over effect. Selenium VBA
Guys, I got around the problem by passing the coordinates to the mouse, here goes the code: 'desbloqueia os pop ups SetCursorPos 985, 70 'x and y position mouse_event MOUSEEVENTF_LEFTDOWN, 0, 0, 0,…
-
0
votes1
answer333
viewsQ: access menu with over effect. Selenium VBA
I am having problems accessing an "interactive menu" using the Selenium library in VBA. follows html code of the page: <html> <head> <meta http-equiv="Content-Type"…
-
0
votes1
answer1001
viewsA: How to capture the td of a web page using Selenium vba?
I got it, the code went like this: Set objCollection = driver.FindElementByXPath("/html/body/table[2]/tbody/tr[2]/td[4]") uasg = objCollection.Text 'captura Uasg…
-
0
votes1
answer148
viewsA: problem to popular an option type control
I managed to get around my error! the problem was occurring because the control I was trying to manipulate was not "accessible". The way was to click the button "select" and interact with popup…
-
0
votes1
answer1001
viewsQ: How to capture the td of a web page using Selenium vba?
html code looks like this: <table> <tr> <td width="01%" class="tex3b"><img height="14" src="/imagens/tm_bullet.gif" width="6"></td> <td width="20%"…
-
1
votes1
answer148
viewsQ: problem to popular an option type control
I have a VBA code but I’m having problems to the popular one element. When having put data in control appears the following error message: runtime error '2146233079 (80131509)': Unknown error:…
-
0
votes1
answer190
viewsA: I am unable to go to the "main2" frame. VBA and Selleniumwrapper
I was able to select the frame and make the interaction, the code was like this: Set objCollection = driver.findElementByCssSelector("frame[name='main2']") driver.SwitchToFrame (objCollection)…
-
0
votes1
answer190
viewsQ: I am unable to go to the "main2" frame. VBA and Selleniumwrapper
I am trying to access a web page and manipulate its controls via VBA and Selennium Wrapper, however, these controls are within a frame with the "name = main2", follows the code VBA: Sub z() Dim…
-
3
votes2
answers3784
viewsQ: What is the difference between a VBA project and a VBA macro?
was studying macros VBA and came to me the following doubt: What is the difference between a VBA project and a VBA macro? Are the two the same or have some significant difference between them?…
vbaasked Daniel Aristofanes 73 -
1
votes1
answer1393
viewsA: VBA - Interneexplorer Object (Frame)
change: Set profileFrame = IEDoc.getElementById("getPathBuffer") ' getPathBuffer = Nome do Iframe Set objCollection = profileFrame.getElementsByTagName("a") 'TAG onde está o link que preciso clicar…
vbaanswered Daniel Aristofanes 73 -
0
votes1
answer236
viewsA: HTML controls problems on a web page with VBA
the error was happening because the tags were inside a Frame, the solution was like this: Sub x() Dim ie As InternetExplorer Dim objCollection Dim ULogin As Boolean, ieForm Dim MyPass As String,…
-
0
votes1
answer236
viewsQ: HTML controls problems on a web page with VBA
I am trying to fill the controls on a web page with an interaction between VBA and IE, I am not able to find and popular the fields related to the date of validity of the minutes. URL Of Page:…