Tagged Questions

-2
votes
0answers
28 views

Browser automation for a Chinese website

I am trying to scrape a Chinese store http://solestage.tmall.hk with Excel VBA. I am registered on this website so have a username and a password. When I navigate to this website, it asks for login ...
0
votes
0answers
16 views

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 ...
1
vote
3answers
206 views

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 ...
0
votes
1answer
562 views

Excel VBA Select Option Website Dropdown List

I am trying to automate this website using VBA excel. I am stuck at one point where I need to select value from the drop-down box. I am very much new to this as this is my first such project. This is ...
0
votes
0answers
36 views

IE.document.*ANYTHING* throws 430 error

I have this code running on one computer, but not another. I hit an error whenever I try to call any of the following. "InternetExplorer.document.getElementById("test") "HTMLDocument....
0
votes
2answers
209 views

Browser automation: Data sets from Excel Vba into Firefox

actually I am using imacros for firefox to automate some things and it works for me. But when it comes to filling out some data sets from an excel sheet to browser for example. Imacros for firefox ...
0
votes
1answer
487 views

Unable to get reference to internet explorer document object vba

I want to be able to access internet explorer using vba Dim ie As InternetExplorer Dim i As IHTMLDocument Dim d As HTMLDocument Set ie = New InternetExplorer ie.Visible = True ie.Navigate "www.google....
0
votes
1answer
153 views

Select dropdown item by vba. Cannot access Iframe.

I want to select drop down item through Excel macro. I cannot refer to the dropdown element by tag name "ddWareHouse" I get error. I think I am really close with attached code. But I this time I get ...
0
votes
1answer
65 views

Tab through a webpage manually

I am trying to navigate through a webpage using just my keyboard. Through the use of my tab key I can enter in data into several input boxes, and press several submit buttons. However I run into a ...
1
vote
1answer
3k views

VBA Error 70: Permission Denied during IE automation

I've been trying to create a quick subroutine in VBA through Excel 2010 to automate putting a list of URLs through bit.ly and copying the abbreviated links back to replace their original link. BUT I'm ...
1
vote
1answer
4k views

Automate download of a dynamically generated file after NTLM Authentication using vbscript/java

I am trying to automate to download a dynamically generated file on a server, so here are the steps what I have to carry out manually - Login to the site using my credentials - It uses NTLM to ...
3
votes
1answer
13k views

Automation Errors: 800706B5, 80004005, 80010108 appear for internal SAP site scrape

I am writing a macro that will scrape my company's internal SAP site for vendor information. For several reasons I have to use VBA to do so. However, I cannot figure out why I keep getting these three ...
1
vote
1answer
10k views

IE 9 not accepting SendKeys

I posted on IE 9 not accepting SendKeys to download a file, but this problem is separate enough from the answer I received to justify another question. My problem is that I can't get IE 9 to accept ...
5
votes
4answers
12k views

Excel VBA SendKeys not causing IE 9 to save download

I am writing a macro that automates the process of downloading a csv file from my company's internal website. For many reasons, I can't use any xmlhttp objects and I have gotten the macro to the point ...