All Questions
Tagged with internet-explorer-11 vba
114
questions
0
votes
1
answer
173
views
Excel VBA IE querySelector button click
Trying to click button using IE.
Due to the firm policy Selenium Basic, is banned. So using that route is not possible.
getting error Object variable not set (Error 91)
code till now.
Global driver ...
- 33
0
votes
0
answers
40
views
Select an option from javascript drop-down on a webpage
So I have a macro to automate a repetitive task of placing meal orders on a website.
(It's annoying because I have to place one order per person per day, and I'm doing it for a lot of people, and ...
- 119
8
votes
4
answers
3k
views
Will VBAs Internet Control function after IE 11 end of life in Jun '22?
Like the title asks,
Certain tools I use rely on VBA code with Internet Control to web scrape and control IE pages. With the IE11 end of life coming next year does anyone have any understanding on how ...
- 99
-1
votes
2
answers
1k
views
Using Excel VBA to load a website that is incompatible with IE11
In Excel VBA to load a website and get it into a sheet I have been using the following:
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE .navigate "https://...
- 301
0
votes
0
answers
551
views
EXCEL VBA (URLDownloadToFile) Not working Due to Site not allowing IE11
I was wondering if anyone had an idea about how to get URLtoDownloadfile to work but get it to use Microsoft Edge as opposed to IE11. The websites trying to pull PDF's from now doesn't support IE11 so ...
- 11
0
votes
0
answers
329
views
Are there alternative ways to execscript on an IE parentwindow in VBA?
I have a VBA macro that opens IE and navigates to a webpage and executes a javascript function on the page. This javascript function accepts a SQL command as an argument that is sent to a database and ...
0
votes
0
answers
94
views
Does IE11 still support dispatchEvent/FireElement?
Where I work we have internal page that used to work with VBA, but I guess since last page or IE update it no longer does.
Macro selects country and then press the button to generate a report for that ...
- 45
0
votes
1
answer
625
views
Excel VBA to select a navigation Tab on a Webpage
Stuck in an area of a webpage and can't seem to figure out how to select any one of the navigation tabs.
I've already gotten through coding for the ID, password and a couple of other screens to get to ...
- 100
0
votes
0
answers
72
views
Run-time error '91': Object variable or With block variable not set (ie.Document.getElementById)
I get the error in the title above when trying to execute a VBA command to click a button on Internet Explorer 11:
Const sURL As String = "MY_URL"
Set ie = New InternetExplorerMedium
...
0
votes
1
answer
431
views
VBA Internet Explorer 11 Open/Save dialog (not the usual popup)
This is not the usual Open, Save, Cancel prompt at the bottom of the IE Window, that one I know how to find with VBA. For some reason on this specific website I get the "old school" type of ...
- 1,805
0
votes
0
answers
577
views
How to run Internet Explorer in background with VBA
I want to run Internet Explorer in background. I used this script and IE is opened but it's a visible window and not run in background.
On Error Resume Next
'Declare a new variable or array variable
...
0
votes
1
answer
87
views
fields of login page not updating as filled in
I'm trying to login to a webpage using VBA & IE automation. I'm hitting what I've been able to solve on other websites, but not this one. When I "click" on the login button of the site ...
- 87
-1
votes
2
answers
221
views
Opening a hyperlink in a new tab of IE
I have an Excel tool that generates links to intranet website. Is it possible to open hyperlinks in Internet Explorer in a next tab instead of new window? Only IE is an option as it's the company ...
- 1
0
votes
1
answer
142
views
VBA using .click on getelment by id keeps loading
I'm creating a script using VBA in excel to open a webpage in internet explorer and push data from Excel to submit the page and move to the next one.
In addition to pushing data to replace the unit ...
1
vote
1
answer
161
views
Fill in the website form with drop-down menu with VBA
Writing the following VBA macro in Excel:
Sub compile()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate "www.google.it"
IE.Visible = True
Do While IE.Busy
...
- 11
1
vote
1
answer
392
views
Is there a way to click on a radio button when Excel VBA says its not visible but it is actually visible?
How do I click on a radio button on the webpage in a form? I am trying to write a code to automate form filling with Excel VBA.
Here is the problem statement: Need to click on one of the three options ...
- 47
0
votes
0
answers
145
views
internet explorer does not always open browser.navigate
Private Sub Command89_Click()
Dim oBrowser As Object
Dim time1, time2
Dim htmlButton
Dim addressInput As HTMLInputElement
Dim err_count As Integer
Dim y As Integer
On Error GoTo Err_Clear
If TempVars!...
- 148
-1
votes
2
answers
1k
views
How to click on a javascript button on IE 11 using VBA?
The VBA code is not responsible because it doesn't work on IE 11 even not programmatically.
The button works with Chrome or Firefox but I cannot manage to use Selenium on my computer, it is throwing ...
0
votes
2
answers
1k
views
Downloading a file using Internet explorer 11 automatically using vba
I am trying to download file using InternetExplorer.Application, but it always opens a window asking to save or open the file. Is there a way to circumvent this and have it run and save in the ...
- 1
1
vote
0
answers
133
views
How to enter data into an Internet Explorer website?
I am trying to enter info into an Internet Explorer 11 website form. The website/form was designed a long time ago (around 15-20 years). The website can only be accessed through Internet Explorer.
I ...
0
votes
1
answer
1k
views
VBA - Send Keys IE11 Save/Open
I have taken code off the boards to send-Keys to the IE11 Save/Open box that pop-ups when you export a file but it is not working (it is sending to the main browser). I cannot activate the Save/Open ...
- 89
0
votes
0
answers
39
views
How to get website to accept the amount updated on a field
I am trying to submit a form after updated all the fields but the amount field keep changing back to zero no matter what amount updated. Below is the element of that particular field:
input id="$...
- 19
1
vote
1
answer
133
views
Unable to fill in some date inputs to perform a customized search
I'm trying to create a script in vba to select dates according to my preferable input date, as in 03/11/2019 and output date, as in 05/11/2019 for the two fields check-in and chek-out. the macro that ...
- 180
1
vote
3
answers
964
views
Excel VBA - Win10, IE11 - opening second webpage is not working
we've migrated to win10 and IE11and some of my vba macros stopped working. I could resolve some, but I am having issues with resolving following problem.
I have a macro, that opens a webpage in IE. ...
- 21
1
vote
1
answer
433
views
How do I pause my code until CAPTCHA is entered?
I have managed to compile the below mentioned code, the code is working fine, but I need to pause the code from running until I enter CAPTCHA value and click proceed button.
How can it be achieved ?
...
- 85
0
votes
0
answers
100
views
Trigger combobox change event
I am working with DATAGRID in web application now, having problem where i can select the object by code , change the value of combobox by code, yet it did no trigger the 'updates' in the application ...
- 5
1
vote
1
answer
107
views
Website not recognizing selection done through VBA code
Below mentioned code is working fine, the problem i'm facing is that when I enter CAPTCHA and click proceed button, the website doesn't recognize the selection for NetBanking Tab, the said selection ...
- 85
1
vote
2
answers
79
views
Unable to autofill tabs of website through excel vba
I have managed to create the below code, but I'm unable to autofill the fields marked with red arrows shown in the image, as there is no ID available for them in the HTML code.
All the tabs shown in ...
- 85
0
votes
2
answers
377
views
Sending double click to Internet Explorer
I want that a double-click on an HTML table row selects the record.
I found the element to send a left-click, but I could not send a double-click. I checked that there was no mouse event control / ...
- 5
-1
votes
1
answer
205
views
I need to copy the Request Url from Internet Explorer into Excel
Is there a way to copy the request Url into Excel using VBA. The code i use at the moment copies the Location Url into Excel. But i really need the request Url. This Url you can find using Developer ...
