Skip to main content

All Questions

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
1 vote
3 answers
8k views

VBA: Choosing Specific Tab on Internet Explorer

I had another post regarding a different issue on the same overall problem here: Converting From Early Binding to Late Binding. I now have a new issue with my coding (which I will post a portion of it ...
user avatar
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
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
1 vote
1 answer
1k views

Finding a button in IE11 (IUIAutomationElement)

I have been trying to use exactly the code given in the link below but I cannot get it to work with IE 11. Automate saveas dialouge for IE9 (vba) Copying the code for convenience: Option Explicit ...
zaptask's user avatar
  • 707
0 votes
1 answer
3k views

How can I automate the download dialog box in IE using VBA?

I'm completely new on here and have only been using VBA for about 6 months. Needless to say, forum posts on here and a few other places have helped me immensely so far. I'm trying to develop a script ...
yousey88'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
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
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
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
1 vote
1 answer
2k views

VBA [EXCEL 2013]: Automation: Open Links in Same Browser Window / Tab

I want to parse with VBA (Excel) a long list of local webpages (.HTM files) and extract some data into excel. There are more than 9000 webpages which the program needs to scrape. This is an example: &...
user3185735's user avatar
-1 votes
1 answer
441 views

Converting From Early Binding to Late Binding

Update # 2 I changed the values of the txtbox and submitbtns with a (0) (and also tried (1) as well), no changes. And I also need to note that the Button has a different name and I updated ...
user avatar