Questions tagged [ie-automation]

65 questions
0
votes
2 answers

VBA IE automation through excel - Get drop down list attribute values

I am trying to get drop down values written into excel, however i am having some difficulties. Heres is the HTML code:
Kestas
  • 43
  • 2
  • 9
0
votes
1 answer

Call a javascript function onclick using vba on a webpasge

Hi I'm trying to figure out a way to call a java script mapped to a button using VBA as part of the web page data entry automation. Following is the code from the site and also the code that I'm working on. Browser code :
0
votes
1 answer

IE automation through VBA - wait for element to disappear

I am filling a web form, which has an built-in preloader animation (which does not impact the browser states) in it, and I am trying to make my script wait for it to be gone, and only then proceed with filling the fields. Currently I am using this…
Kestas
  • 43
  • 2
  • 9
0
votes
2 answers

VBA code works in debug mode, but fails in run mode

I am trying to fill one input field in Internet explorer, but the code is only working in debug mode, while I am pressing F8 on each of the actions. When I am running the code automatically, the value fill is not working, the input field remains…
Kestas
  • 43
  • 2
  • 9
0
votes
1 answer

Completing IE Form By Using Elements

I'm trying to use VBA to enter a value into an input box but having no luck! below is my code and the HTML from the website VBA once the website is open: IE.GetElementByID("searchForm").Value = "test" HTML inspecting element:
0
votes
1 answer

IE automation, automated login to a particular page

I am trying to automate login to a page through Internet Explorer with VBA code, however, I am stuck as I am not able to identify the login and password fields, as they do not have any ID or Tag name. Is there any way to use xPath or some other…
Kestas
  • 43
  • 2
  • 9
0
votes
0 answers

VBA-IE: Click on HTML element with only a href attribute

I need to go to the next page by clicking "Anmelden". enter image description here This elements are described in html code as:
0
votes
1 answer

PowerShell: Testing whether an element exists in web page

I am trying to find whether an element exists in a web page: $ie = New-Object -com InternetExplorer.Application $ie.visible = $true $ie.Navigate("http://10.0.0.1") BrowserReady($ie) # wait for page to finish loading if…
Colin Wu
  • 611
  • 7
  • 25
0
votes
3 answers

Can I automate a website using xpaths in vba?

I am trying to automate downloading files from a website. I have used xpaths to control a website in java in the past, and would like to use them in VBA for this project. Is it possible to use something like getElementByXpath() and if so, what…
0
votes
3 answers

Powershell null-valued expression error

I'm new to Powershell, and I've been struggling with this issue for longer than I care to admit. I am trying to automate the filling out of an intranet webform, and I thought this would be very simple. I've already got the login component worked…
0
votes
0 answers

IE.Document.Frames("frame_name") fails while Set IEDoc -> IEDoc.Frames works

I'm trying to set a final target frame in one line, but somehow IE.Document works only if it's assigned to a variable. So the following statement works: Set IEDoc = IE.Document Set objFrameMain = IEDoc.frames("frame_name") while this one fails with…
laooglee
  • 137
  • 13
0
votes
2 answers

IE-Automation: Stuck with debuging only first instance of loop is done correctly, but loop does not break

I have written code which navigates to websites goes to inner page expands details and then copies HTML tables to newly created sheet. Navigation loop is without issue it loops correctly through all elements and expands details correctly. The…
Petras K
  • 163
  • 2
  • 15
0
votes
1 answer

Clicking a button in IE using VBA

I am using Excel VBA to try click a button on a site, here's the code from the site using inspect element: And here's what i'm doing in VBA: Sub testcode() Dim ie As…
Exam Orph
  • 365
  • 9
  • 18
0
votes
1 answer

Need to automate IE with drop down menu using Excel VBA

I want to automate a site having drop down menu named 'Timesheet' and then click on the Menu item 'Project' which is 3rd in the list. Here is the HTML code:
0
votes
1 answer

Handling windows opened while uploading files in IE using VBScript

In IE automation, how to handle window that opens when 'upload files' or 'attach' button clicked through vbscript? To be clear, I've automated until the 'upload' button pressed. After that I need to fill the file path and open button needs to be…
Joseph
  • 1
  • 2