Skip to main content

All Questions

0 votes
1 answer
393 views

IE11 Automation via Excel VBA - Forms

This is part 2 from my original post here. So now once logged in, I have to make two clicks to display the information I'm ultimately trying to scrape. I cannot seem to figure out the proper way to ...
user9837831's user avatar
3 votes
1 answer
276 views

IE11 Automation via Excel VBA - company webpage

First I'm very new to trying to automate IE via Excel VBA. That being said, I'm working to automate a login to a company-specific webpage (only accessible to our employees). The goal is to automate ...
user9837831's user avatar
2 votes
1 answer
402 views

Unable to set timeout option within my scraper to save it from infinite looping

I've written a script in vba using IE to initiate a search in a webpage in it's searchbox to populate the result according to the search by hitting the search button. The webpage loads it's searchbox ...
SIM's user avatar
  • 22.3k
2 votes
1 answer
375 views

Trouble making my parser scroll downward

I've written a script in vba to parse some information from a webpage. The thing is before scraping any information from that webpage I need to make my scraper scroll downward for few times. Here is ...
SIM's user avatar
  • 22.3k
3 votes
3 answers
1k views

Unable to parse some links lying within an iframe

I've written a script in vba using IE to parse some links from a webpage. The thing is the links are within an iframe. I've twitched my code in such a way so that the script will first find a link ...
SIM's user avatar
  • 22.3k
7 votes
2 answers
1k views

Unable to scroll a split screen of a webpage

I've written a script in vba to scrape some items from a webpage. By default, there are 4/5 items visible when I open that page. However, the webpage displays it's rest of the items when it is made to ...
SIM's user avatar
  • 22.3k
3 votes
1 answer
558 views

Is there any keyword in vba to clear the default values in a website to replace with a new one?

While filling in different forms, username, inputbox or similar things in different websites, I sometimes noticed that the very options [forms, username, inputbox] are already filled in with default ...
SIM's user avatar
  • 22.3k
11 votes
2 answers
645 views

Scraper throws errors instead of quitting the browser when everything is done

I've written a scraper to parse movie information from a torrent site. I used IE and queryselector. My code does parse everything. It throws errors instead of quitting the browser when everything is ...
SIM's user avatar
  • 22.3k
2 votes
1 answer
10k views

Excel VBA Code Not Working With Internet Explorer 11

I have a vba code which can upload the data from an excel sheet to a website. However, the code works fine in IE browser 8,but it does not work on a win8 IE browser 11. It gives error 438 ("Object ...
Syed Atif's user avatar
1 vote
1 answer
261 views

VBA IE11 locking in a change to a dropdown value

I'm using VBA to open a website, login, and navigate to a certain page. There is a dropdown with 8 options. I used this code to change the dropdown to the value I want, but it always reverts back ...
acvbasql's user avatar
  • 109
0 votes
0 answers
288 views

Excel Visual Basic produces The object invoked as disconnected from its clients

My macro uses Internet Explorer to open PeopleSoft Financials and then run a public query. It has been working for a long time until recently. I'm aware of an update to Internet Explorer on our ...
Shaves's user avatar
  • 900
0 votes
0 answers
1k views

Excel CreateObject InternetExplorer: Object creation by ActiveX Component not possible

I have an intranet web app (Java, Talend Open Studio) which creates an Excel 2013 XLSM with a simple macro. Depending on user selection, the xlsm contains, besides other data, between 0 and 15 links ...
user2037828's user avatar
0 votes
0 answers
472 views

VBA: IE automation stops with new tab open

A link that I click on via IE automation opens a new tab. With this new tab how can I control it with out creating a new internet explorer object? If Format(IE.Document.getElementById("...
Quint's user avatar
  • 590
0 votes
1 answer
1k views

Convert HTML Table to Excel on IE 11

I want to create xls(excel) file from html table structure using IE 11. I have gone through some solutions on site, however none of them works on IE11. I am using Angular2.
varun chandwani's user avatar
0 votes
1 answer
260 views

Submitting form on child window

I have a vba script that automatically navigates its way through ups.com. It does just fine until it comes to a child window with a different url. In that child window is a simple form, but when the ...
Matt Cremeens's user avatar

15 30 50 per page