Questions tagged [ie-automation]

65 questions
3
votes
0 answers

Internet Explorer Automation: Accessing elements under Multiple Frames

I am working on an automation which opens an intranet site in Internet explorer, inputs data and submit the information. However the site is using multiple 'iframes' and 'frames' i.e. Under top level 'iframe', there will be another 'iframe' and…
Joseph K
  • 31
  • 2
3
votes
1 answer

Automate IE via Excel to fill in a dropdown and continue

Admittedly still a newbie with automating IE via Excel but would appreciate whatever help anyone can offer with this. Basically, this opens up a webpage, selects a button, fills in 2 dropdowns, enters a value and then presses another button to…
John Wilson
  • 100
  • 1
  • 7
3
votes
2 answers

Using VBA to select drop-down values on a website

I am trying to create a macro which pulls a report from a website and this has four drop-down lists to select values. I am able to login to the page and direct myself to the report page, but for some reason am having trouble with the drop-down…
Francis
  • 129
  • 2
  • 12
3
votes
0 answers

Selenium IEDriver not able to view pdf

I have a button in IE, when clicked on the button it opens a new window with a pdf file in it. while using IE webdriver, pdf is not loaded on the new window, the new window is blank and doesnt have any content. It works well with Chrome-driver and…
3
votes
1 answer

Set iDoc = IE.Document gives run-time error in VBA

I am having strange issue. I am using 32 bit version IE 10. End user is using 64 bit version IE10 For me set iDoc = IE.Document works fine in below code snippet. But for end user I get "Type mismatch error". Below is my code: Function Run() As…
TechGeek
  • 2,172
  • 15
  • 42
  • 69
2
votes
2 answers

Using VBA to click on a link/button in an IE web page

I have read a lot of information on using VBA to click on a link in IE, but I cannot get it to work in my case. The relevant HTML code is as follows:
TMc
  • 55
  • 3
  • 9
2
votes
3 answers

Internet Explorer instance DocumentComplete not firing

I am trying to create an instance of Internet Explorer from a WPF application, load a saved local file, and do some further processing once the file is loaded. However, although the file is visible in the Internet Explorer window, the…
Zev Spitz
  • 13,950
  • 6
  • 64
  • 136
1
vote
2 answers

filling a html auto search box and obtaining the results

I am trying to fill in a search box on a web page that as it is filled in it auto searches for the results. The website is https://pcpartpicker.com/products/motherboard/. If you go there and type in a motherboard manufacturer of motherboard name…
awsmitty
  • 121
  • 1
  • 2
  • 10
1
vote
1 answer

How to take value from excel workbook to find something in a web form dropbox

I am working on a web automation project. I have come up to a web drop box to where I have to choose a value. I have a query selector which works fine in doing the job but now I want that query selector to find those values in the drop box which are…
Dev
  • 25
  • 6
1
vote
0 answers

How to handle stuck download button in VBA internet automation

I am writing code to automatically download a spreadsheet from a website, by simulating a series of button clicks. (Has to be done this way, winHTTP methods won't work for other reasons). The code clicks a download button, then clicks the save and…
1
vote
2 answers

Click on Href link through vba

I am trying to create IEautomation through vba-excel for the following link. URL: http://qpldocs.dla.mil/search/default.aspx The code includes search for the string "QPL-631",and click on the corresponding java script link MIL-I-631D(6).When I…
Neelesh
  • 138
  • 1
  • 10
1
vote
1 answer

how to click a link in IE using excel VBA

I am trying to wrote some code that will lookup a word in an excel cell, the search for that word and, most importantly, click on the link that returns. I have the search part down, but it's the click on the link I'm struggling with. the HMTL…
Simon B
  • 11
  • 2
1
vote
3 answers

VBA IE automation - wait for the download to complete

I am trying to automate some tasks which are being done through Internet explorer, which include downloading a file and then copying it to a different directory and renaming it. I was more or less successful in finding the information on how to do…
1
vote
1 answer

IE Automation Issue

I have a code to navigate to a website and fill up a form with 33 inputs. This is the code: Dim i As Long Dim IE As Object Dim objCollection As Object Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.Navigate…
Guilherme
  • 161
  • 3
  • 14
1
vote
0 answers

Close Internet Explorer msg box. FindWindowEX function? childHWND?

I'm looking for the solution to close IE browser message box, using Internet Automation in VBA. See attached photo of the screen. I am not considering keypress event as a good way to do it. However I found piece of the code which "smells good" for…
1
2 3 4 5