Hi. I am using Access. I created a function to open a webiste, login into it and navigate to other pages. The problem is: When i do the debug.print of the locationurl of the second page, the url is unmodified form the first one. Playing the same function step-by-step it works perfectly. Do u know why?
It might be something where you have reassigned your "URL" variable so that it changes based on the page you're on. It's sounding like you grabbed it early in the process but when you navigate to the page you didn't grab it again.
would you know if it's possible to fill a div with text using that library? Assuming IEElement is a div element I tried IEElement.innerText = "set this text" but it didn't work
Hey Daniel, yes you should be able to change the text of a "Div" element using VBA. However, it is assumed you selected the right Div element. Do you have the code that you used?
Hello, ! thank you for the tutorial. ine the line with "Set IEDocument = IEObject.Document", I got this error "Run time error '2147467259' automation error unspecified error. Do you know the root cause of this ?
Hello @Sigma Coding, As you mentioned information about this subject is extremely limited, thus, I would like to ask you some help on how to select from AJAX dropdown menu using VBA. The website in question is "portal.emsa.europa.eu/widget/web/thetis/inspections/-/publicSiteInspection_WAR_portletpublic" and the specific dropdown is "Flag". Thank you for your support. All the Best, Eduardo
So this could be very complicated, and I'm going to recommend you don't do this with VBA. What exactly are you trying to do once you select the item from the drop-down?
Hi. I am using Access. I created a function to open a webiste, login into it and navigate to other pages. The problem is: When i do the debug.print of the locationurl of the second page, the url is unmodified form the first one. Playing the same function step-by-step it works perfectly. Do u know why?
It might be something where you have reassigned your "URL" variable so that it changes based on the page you're on. It's sounding like you grabbed it early in the process but when you navigate to the page you didn't grab it again.
Awesome explanation. Thank you
would you know if it's possible to fill a div with text using that library?
Assuming IEElement is a div element I tried IEElement.innerText = "set this text" but it didn't work
Hey Daniel, yes you should be able to change the text of a "Div" element using VBA. However, it is assumed you selected the right Div element. Do you have the code that you used?
Hello, ! thank you for the tutorial.
ine the line with "Set IEDocument = IEObject.Document", I got this error "Run time error '2147467259' automation error unspecified error. Do you know the root cause of this ?
Thanks
Hello @Sigma Coding,
As you mentioned information about this subject is extremely limited, thus, I would like to ask you some help on how to select from AJAX dropdown menu using VBA. The website in question is "portal.emsa.europa.eu/widget/web/thetis/inspections/-/publicSiteInspection_WAR_portletpublic" and the specific dropdown is "Flag".
Thank you for your support.
All the Best,
Eduardo
So this could be very complicated, and I'm going to recommend you don't do this with VBA. What exactly are you trying to do once you select the item from the drop-down?
@@SigmaCoding Hello! I managed to learn and apply the HTTP "POST" request and managed to succesfully end my project!
Благодарю!!! Ты мне очень сильно помог искал , как получить нужный tag