Publicar un concurso

Download data from HTML to Excel

Estado: Closed
Premio: $10
Propuestas recibidas: 2
Ganador: num13

Winner

Resumen del concurso

Hi all,

I have to update in a regular basis some databases that are sourced from HTML websites. In the website you have to select certain parameters to generate the report (such as specifying the date, the id of the report wanted, etc). Normally I use a web query in excel to download the data without going directly to the website. The issue is that sometimes I need to download to excel the same report changing only few parameters of the search keeping the rest of them constant. It is really time consuming to run manually the web query each time this is why I need someone to write in Visual Basic the codelines needed to make a loop of a web query with the goal that it will download the data for each of the reports generated in the HTML website for each set of values determined for each parameter.
I need it to be in Visual Basic as it is the programming language that I understand and I need to explain it to the rest of the team.
I know it is easier to use a specific example for programming so you should use the following case that I am going to explain:
Overview:
1. The macro programmed in Visual Basic should make excel go to a specific URL
2. Use a specific set of values for each parameter needed for generating the report.
3. Download the result as text only to a worksheet
4. Add as many columns as parameters used in the report generation which will display the value of each parameter used for that case.
5. Repeat the same process for each set of values needed, downloading the results to the same worksheet just below the previous report downloaded.
Link: http://www2.chileautos.cl/cemagic.asp?region=0&ciudad=37&tipo=Todos&carroceria=&maresp=12&modelo=Rio+5&combustible=0&kilom=&c_otros=&cili=0&cilf=0&vendedor=0&ai=2014&af=2017&pi=7000000&pf=9000000&fecha_ini=01%2F09%2F2015&fecha_fin=11%2F09%2F2016&disp=1&dea=100&pag=1&boton=4
Parameters: the number of parameters in this URL is 22.
region, ciudad, tipo, carroceria, maresp, modelo, combustible, kilom, c_otros, cili, cilf, vendedor, ai, af, pi, pf, fecha_ini, fecha_fin, disp, dea, pag, boton.
Set of values: the number of set of values is 20. All the parameters will have the same value in each set except for pag that will change from 1 to 20.

Constant parameters: region=0, ciudad=37, tipo=Todos, carroceria=, maresp=12, modelo=Rio+5, combustible=0, kilom=, c_otros=, cili=0, cilf=0, vendedor=0, ai=2014, af=2017, pi=7000000, pf=9000000, fecha_ini=01%2F09%2F2015, fecha_fin=11%2F09%2F2016, disp=1,dea=100, boton=4
Variable parameter= pag=i with i from i=1 to i=20.
Please keep in mind that I am interested in getting the code lines more than the output itself. I do not want the results only, I need to see how you programmed the macro.
Thank you!
Cristobal

Habilidades recomendadas

Winner

Publica un concurso similar

Comentarios del empleador

“Excellent work! I would definetly like to hire him for future projects.”

cbucher, United States.

Tablero de aclaración pública

omarfarukmunna
- 7 años atrás
prize is too low
- 7 años atrás
sithalchordia
- 7 años atrás
contest prize is too too low... please increase prize money #increaseprize
- 7 años atrás
stcserviciosdiaz
- 7 años atrás
hola, me gusta u proyecto.!!! si pudieras escribirme al privado para hablar los detalles del trabajo, estoy disponible las 24horas. greeting.!
- 7 años atrás
DavidYac123
- 7 años atrás
Hello! I can to help you in your homework. But it`s not a proyect. this is a work. Please, write me in my imbox i´ll help you!
- 7 años atrás