PDA

View Full Version : How to create a macro that opens a webpage and introduces text into a form !



AlexCociorva
05-07-2012, 02:38 AM
Hi all,

I have a problem creating a macro that opens a web page, goes to a specific section of the page (by clicking on a link), introduces a captcha code (from an image) and then imports into excel the tables shown above the form. Then goes to the following page of tables and imports (through a link) the next section of data tables and so on (10 pages). Other problem is that the specific page refreshes after a short while and you won't be able to see the data, unless you enter the code from the image again.

The webpage is: e-licitatie.ro, then from the main page i have to go to 'Anunturi de participare' from 'Anunturi' section, and there introduce the code from the image and click on 'Cauta'.


Hope you can help me on this one!
Thank you very much!

Regards,
Alex

BrianMH
05-08-2012, 12:13 AM
The purpose of captcha codes are to stop automation. They aren't computer readable, at times hardly human readable. I doubt there will be a vba solution for this.