Skip to main content

All 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 ...
jan benes's user avatar
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
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 ...
S123C22's user avatar
  • 11
0 votes
0 answers
255 views

Microsoft IE open dialog Box and Microsoft Edge Open Dialog Box Different in behaviour

We have ASP.Net application - User clicks on a link and system show and an open dialog box with FROM (URL) as a label - User then clicks OPEN. Excel file open in EXCEL as READ-only- Excel File Path ...
Malik's user avatar
  • 9
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 ...
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
-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 ...
Dr3wno's user avatar
  • 1
0 votes
2 answers
206 views

Content-disposition inline

In our application we are exporting the excel and we have below code snippet in our code Response.AddHeader("Content-Disposition", "inline;filename=somefile.xsl") Our application only supports in IE,...
user9757558's user avatar
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
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 ...
joiner's user avatar
  • 47
0 votes
1 answer
786 views

IE 11 & Office 365 - getting Excel to open instead of being prompted

Windows 10, IE 11, Office 365 Desired behavior: From a website that runs reports (Crystal, but inside a custom web application), click on View Report button, Excel opens in a new window and report ...
steve_o's user avatar
  • 1,243
-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 ...
Pierre Qui Roule's user avatar
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 ...
learningvbahurts's user avatar
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. ...
mikit's user avatar
  • 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 ? ...
Arpit Jain's user avatar
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 ...
Smarter's user avatar
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 ...
Arpit Jain's user avatar
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 ...
Arpit Jain's user avatar
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 / ...
Smarter's user avatar
-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 ...
Y Bisschoff's user avatar
2 votes
1 answer
540 views

getElementsByTagName is not finding "Input" or "td" tag with ID in it

I'm attempting to navigate a webpage in IE11. The page is internal work related so I cannot share the page. I have navigated multiple pages from the site without any issue, until I have reached a date ...
TBoulz's user avatar
  • 351
0 votes
0 answers
34 views

IE closes window and connects directed link in new window

I have been looking for a solution or cause of this issue but I couldn't find anything. My problem is that I am going to a link with vba macro and this link direct me to another link but problem is ...
Zeynel ÖZTÜRK's user avatar
0 votes
1 answer
177 views

Excel Automation with IE

my original question posted Simulate Double Click Event in IE EXCEL , VBA interaction .
Smarter's user avatar
1 vote
1 answer
90 views

Trying to Populate IE Input Box, Click Submit, then Retrieve a Value from IE

I am trying to automate the retrieval of domain name values from GoDaddy's valuation service located at: https://www.godaddy.com/domain-value-appraisal I have done close to 400 manually but it is ...
ONDEV's user avatar
  • 566
1 vote
2 answers
328 views

Error code 91 Object variable or With block variable not set

I'm trying to perform a web automation, which involves logging in and search for a particular text on my spreadsheet on to particular box on the webpage. I'm Encountering an error in the 2nd step to ...
James D Con's user avatar
2 votes
0 answers
196 views

How to add elements revealed by click action to elements list in Excel VBA for an html web form

I'm trying to set up an Excel form that auto-fills an HTML web form. I've figured out how to use VBA to get the elements and cycle through them to add values. My issue is with a text field that is ...
gramzad's user avatar
  • 21
0 votes
1 answer
1k views

.ReadyState & .Busy Is Not Waiting For IE Page To Load

I have some VBA to launch a company intranet site which will bring me directly to the document I am searching for. I need to wait for the page to finish loading, and then hit the "Print" button which ...
TBoulz's user avatar
  • 351
0 votes
1 answer
285 views

Unable to get rid of blank screen popping up while scraping content

I've created a macro to parse the name of different movies traversing multiple pages from a torrent site. I used InternetExplorer in combination with Html.body.innerHTML parser (usually used with ...
robots.txt's user avatar

15 30 50 per page