Hi guys. Would really appreciate if you could help me with general guidance on how to build a macro that would perform the following steps. My knowledge on VBA and HTML is quite basic, but I'm willing to learn as necessary.
1. Go to: http://www.crautos.com/usados/economicos-usearch.cfm
2. Change one or more criteria on the "search table" at the bottom of the page (for instance, selecting Audi on the 'Marca' drop-down list).
3. Click on "Buscar"
4. Click on the first car (either brand, model or year; it's the same).
5. Copy data on "Datos Generales" into Excel
6. Go back (back button of browser)
7. Click on next car
8. Go to step 5
My goal is to automatically build (and update periodically) different databases with the cars (and their characteristics) available for sale, based on different criteria on the "search table".
Thank you very much,
Jose
http://www.ozgrid.com/forum/showthread.php?t=177775
Bookmarks