Skip to main content

All Questions

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 vote
1 answer
1k views

Excel VBA to populate I.E. causes Run-time error in I.E. 11 but not 9

I created a sub to populate form fields in a website with data from an Excel workbook The sub opens a new window in Internet Explorer, navigates to a intranet site, and populates form fields with ...
Jude's user avatar
  • 11
1 vote
1 answer
3k views

How to get correct class element from HTML using VBA

I am trying to extract this website using VBA This is the HTML I want to Target <div class="claim"> <div num="1" id="US-6627754-B2-CLM-00001" class="claim"> to get data for various ...
Rahul's user avatar
  • 11.3k
0 votes
0 answers
134 views

My VBA code worked fine on IE9, but it doesn't work on IE11

I want to reset Setting on a page but click event is not fire on this Setting button. It work fine on IE9 but when I upgrade to IE11 it doesn't work. This is my code: Sub resetIEvalue() Dim ...
PAINOLAND's user avatar
0 votes
2 answers
5k views

vba can not find opening IE 11 Browser.

I have a vba code which can upload the data from an excel sheet to a website. However, the code works fine in Win7 System and IE browser 8,but it does not work on a win8 IE browser 11. Here are part ...
Lingfeng Ye's user avatar
2 votes
0 answers
157 views

form submitting with onLoad input values instead of user inputted values when automated with VBA

Main Issue: When I submit a form using vba, the form's inputs' values change unexpectedly. I'm looking to see if there's an issue I don't know of with document.forms().submit in vba that might be ...
Kevin Dolan's user avatar
0 votes
1 answer
569 views

VBA IE 11 Runtime

I have coded VBA in IE 11 before, and have been able to work around problems, but on this I keep getting an Error 91 or Error 424. While sometimes it works perfectly. Unfortunately I cannot share ...
Aaron Hellman's user avatar
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
0 votes
1 answer
2k views

ReadyState substitute for IE11 in VBA

Please, I've just bought a new pc that came with IE 11. I have a lot of codes in VBA using the While ie.Busy Or ie.ReadyState <> READYSTATE_COMPLETE: DoEvents: Wend But it seems that ...
victor's user avatar
  • 1

15 30 50 per page
1
4 5 6 7
8