Questions tagged [ie-automation]

65 questions
0
votes
2 answers

Automate click(expanding) plus signs within internet explorer

I am working on automating some data entry into an intranet web page. I have had success with this type of code in the past to click checkboxes, but have been unable to make it work on the plus signs that expand the rows. The below code does…
Richard Lusch
  • 1,050
  • 10
  • 19
0
votes
1 answer

VBA IE Automation: Get URL from within element

I am trying to get the URL from inside the second element in the "pShowMore" class. I have this: For Each wd In CreateObject("Shell.Application").Windows If InStr(wd.LocationName, "Institution") <> 0 Then Exit For End If Next…
-1
votes
1 answer

Copy text from an IE page and paste it back to a text box in the same page using excel VBA

Using Excel VBA, am trying to create a macro. Purpose is to make it navigate across Internet explorer for a task. Am trying to copy a text from from red marked box (each are separate entries) within a web page and paste that to an input box above in…
-1
votes
1 answer

Automated internet explorer in Excel to search multiple items on a site

I am using excel 2013 with a worksheet containing a column of license numbers. The macro needs to cycle through each cell to be searched on the webpage. Once searched it grabs some details from the search result page and puts it in the cell next…
C LeRoy
  • 1
  • 1
-2
votes
1 answer

Getting IE Automation Error "Object variable or with block variable not set"

I am Getting error while automating an existing IE window. error is "Object Variable or with block variable not set" Code is Sub accessExistingIEBrowser() boolWindowFound = False Set objShell = CreateObject("Shell.Application") …
1 2 3 4
5