Download data from HTML to Excel

  • Durum: Closed
  • Ödül: $10
  • Alınan Girdiler: 2
  • Kazanan: num13

Yarışma Özeti

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: [login to view URL]
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

Tavsiye Edilen Beceriler

İşveren Geribildirimi

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

Profil Görüntüsü cbucher, United States.

Bu yarışmadan başlıca girdiler

Daha Fazla Katılım Görüntüle

Genel Açıklama Panosu

  • omarfarukmunna
    omarfarukmunna
    • 2 yıl önce

    prize is too low

    • 2 yıl önce
  • sithalchordia
    sithalchordia
    • 2 yıl önce

    contest prize is too too low... please increase prize money #increaseprize

    • 2 yıl önce
  • stcserviciosdiaz
    stcserviciosdiaz
    • 2 yıl önce

    hola, me gusta u proyecto.!!! si pudieras escribirme al privado para hablar los detalles del trabajo, estoy disponible las 24horas. greeting.!

    • 2 yıl önce
  • DavidYac123
    DavidYac123
    • 2 yıl önce

    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!

    • 2 yıl önce

Yarışmalara nasıl başlanır

  • Projenizi ilan edin

    Yarışmanızı İlan Edin Hızlı ve kolay

  • Tonlarca girdi alın

    Tonlarca Girdi Alın Bütün dünyadan

  • En iyi girdiyi seçin

    En iyi girdiyi seçin Dosyaları indirin - Kolay!

Şimdi bir Yarışma İlan Et ya da Bugün Bize Katılın!