Download data from HTML to Excel
- Tila: Closed
- Palkinto: $10
- Vastaanotetut työt: 2
- Voittaja: num13
Kilpailun tehtävänanto
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
Suositellut taidot
Työnantajan palaute
“Excellent work! I would definetly like to hire him for future projects.”
cbucher, United States.
Julkinen selvennystaulu
Kuinka päästä alkuun kilpailuiden kanssa
-
Ilmoita kilpailusi Nopeaa ja helppoa
-
Vastaanota tonnikaupalla osallistumisia Ympäri maailmaa
-
Myönnä palkinto parhaalle työlle Lataa tiedostot - Helppoa!