Skip to main content

All Questions

15 votes
1 answer
582 views

Can't click on some dots to scrape information

I've written a script in vba in combination with IE to click on some dots available on a map in a web page. When a dot is clicked, a small box containing relevant information pops up. Link to that ...
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
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
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
6 votes
1 answer
18k views

Internet Explorer VBA Automation Error: The object Invoked has disconnected from its clients

I'm trying to write code that will read a value from Excel, look it up in an internal web based system and store the results back in the Excel. It reads the Excel with no problem, opens Internet ...
PKatona's user avatar
  • 639
4 votes
2 answers
836 views

Unable to let my script keep clicking on Load more button using IE

I've created a script in vba using IE to keep clicking on the Load more hits button located at the bottom of a webpage until there is no such button is left. Here is how my script can populate ...
MITHU's user avatar
  • 180
4 votes
1 answer
12k views

How to fill webform

I want to update the fields in website using Excel values. I found this macro online and tried to edit it. How do I update fields once login is successful? I have added following references: ...
J.B.'s user avatar
  • 445
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
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
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
2 votes
2 answers
147 views

Unable to apply regex within vba IE

I've written a script using vba in combination with IE to parse the contact information from a webpage applying regex on it. I searched a lot but could not find any example that can satiate my ...
SIM's user avatar
  • 22.3k
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
2 votes
1 answer
183 views

VBA - losing control of internet exploror

I have a function that loads a website prompting a user to login. This works on everyone's computers except one person and I cannot figure it out. I get a runtime error on the line Do Until ieApp....
ArcherBird's user avatar
  • 2,094
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

15 30 50 per page
1
2 3 4 5
8