Skip to main content

All Questions

0 votes
1 answer
168 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 ...
jan benes's user avatar
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 ...
Floyd's user avatar
  • 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 ...
Rufom1's user avatar
  • 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://...
drb01's user avatar
  • 301
0 votes
0 answers
550 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 ...
S123C22's user avatar
  • 11
0 votes
0 answers
325 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 ...
melonplant's user avatar
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 ...
Radas's user avatar
  • 45
0 votes
1 answer
623 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 ...
John Wilson's user avatar
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 ...
Lucas Contreras's user avatar
0 votes
1 answer
430 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 ...
Ricardo A's user avatar
  • 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 ...
user14448790's user avatar
0 votes
1 answer
85 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 ...
Jim Carney's user avatar
-1 votes
2 answers
220 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 ...
Dr3wno's user avatar
  • 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 ...
Amjusthere's user avatar
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 ...
Markus's user avatar
  • 11

15 30 50 per page
1
2 3 4 5
8