Stack Overflow
Stack Overflow

Questions tagged [ie-automation]

65 questions
0
votes
1 answer

Excel IE Automation identifying a "css" element

Still plundering along scraping web sites, printing from web pages, etc. but ran into a snag I'm hoping someone can help me with. The pic below is shows the tab that I'd like to activate and I have the code to get me right there but can't activate…
John Wilson
  • 100
  • 1
  • 7
0
votes
1 answer

How to set focus to IE child page to control it

I must be missing something really simple here but I can't seem to find the answer to it. Here's the code I'm using to get me to a particular point in my routine: Dim objShell, IE_count, x, my_url, childPage Set objShell =…
John Wilson
  • 100
  • 1
  • 7
0
votes
1 answer

Powershell IE Automation- Can't Set value for Text area

I'm looking at a web page with a textarea: I want to set value of the textaea, however in doing…
Divya Mahajan
  • 1
  • 3
0
votes
1 answer

Using VBA to click a javascript link, get "object required" error

I am attempting to access a website on IE using VBA to pull a report of the previous weeks transactions. I was able to login and navigate to the report page. However, when I try to click a link for an advanced search I get the error "Object…
Paul Szorik
  • 3
  • 2
0
votes
1 answer

Tracking HTML Element Class With VBA

I have been searching the web for an answer but couldn't find anything useful so far. Question is as simple as the title actually. I have some elements in a web page and I would like my macro to perform actions only when they have/not have a…
Zeynel ÖZTÜRK
  • 3
  • 2
0
votes
1 answer

write-output returning nothing with a PSCustomObject on first launch

I have a automated IE script (powershell 2.0) to webscrape a serial number. The script bypasses a login page, and scrapes a serial number off a certain page. However i am having issues in write-output said serial number on the first run of my…
Joshfromnz
  • 45
  • 4
0
votes
0 answers

IE drop down list not working, className and id's is dynamic

Can someone help me on web page automation. I have a dynamic web page that needs to be automated using VBA Excel. But the problem is when it is dynamic and its className and Id's get changes every time web page refreshed. I need to click on a drop…
chichi
  • 1
0
votes
0 answers

Selecting Row from table with VBA

I am trying to select a row in html table and then click the activated Select/Submit button. Even though I am able to locate the row item, I cant perform Click action. By clicking this row I should see class change and Select button should be…
Zeynel ÖZTÜRK
  • 3
  • 2
0
votes
0 answers

IE closes window and connects directed link in new window

I have been looking for a solution or cause of this issue but I couldn't find anything. My problem is that I am going to a link with vba macro and this link direct me to another link but problem is my first initiated window is closing and directed…
Zeynel ÖZTÜRK
  • 3
  • 2
0
votes
2 answers

How is this button clickable via vbs in ie?

I am trying to automate e few simple processes on the client side of a web service in our internal net. The little program is supposed to handle a few simple clicks, that everyone has to do. The automation works, yet the very first step is driving…
xiles
  • 1
  • 1
0
votes
2 answers

How to click on the download botton while exploring the PDF in IE11 through excel VBA

Sub Drop_Down() Dim objIE As Object, ele As Object, opt As Object Set objIE = CreateObject("InternetExplorer.Application") objIE.Visible = True objIE.navigate "https://isgs-oas.isgs.illinois.edu/reports/rwservlet?oil_permit_activity" Do While…
Partha
  • 5
  • 6
0
votes
2 answers

Excel VBA - Exporting and saving SSRS report

Looking for help with pulling an SSRS report from an internal company site using VBA. I've read several posts on VBA automation and have been managed to successfully make all the selections and run the report, now I just need the data. Specifically,…
Martin Smith
  • 11
  • 1
  • 2
0
votes
2 answers

Call an event from a website - using VBA to Internet Explorer

I'm using VBA in Microsoft Access for Internet Explorer automation. I've already open the website that I want, but there is an input that when typing the text inside, and pressing enter, the website tries to validate the data and fill other fields…
tdmsoares
  • 533
  • 7
  • 24
0
votes
1 answer

Convert VBA Code to VB.NET for use in SSIS Script Task

The purpose of this is to download an excel file from internet explorer using IE Automation and UI Automation to work with the Frame Notification Bar in internet explorer. After spending quite some time with UI Automation in VBA, I have…
Adib Akale
  • 105
  • 9
0
votes
1 answer

Internet Explorer Automation Frame Notification Bar using Visual Basic SSIS Script task and UIAutomation

I am using a Visual Basic script task in Visual Studio's SSIS to automate downloading an excel file from https://www.fincen.gov/msb-registrant-search. I have no issues with navigating to the site and clicking on the blue View/Download link. The…
Adib Akale
  • 105
  • 9
1 2
3
4 5