how to develop macro to download report from online website in excel format

[stggst]

I am very new to the macros.I want to know can we develop a macro to download report from online website.based on the names which i can select form drop-down list,i want to download same reports for each name.can i do this using macros. Please help me to do this.

 

[gruntingmonkey]

You need to read up on HTML Scraping. Is the website open to all or does it have username, password etc?

 

[stggst]

it has username and password.more like sap ERP system

 

[gruntingmonkey]

Can you give me the link to the initial site?

 

[stggst]

cant we do it without link? give me some times if it is necessary i will send you

 

[gruntingmonkey]

You need to use the code behind the link - go to the webpage and press F12. I can write the first bit for you if you send me the link - I don't need usernames or passwords. Hopefully, with that as a starter then you can do the rest.

 

[stggst]

ok this is the link Welcome to Platform Red
are youdeveloping a macro only appear the login window?

 

[vds1]

Here is the good post to start

Navigate Internet Explorer using VBA - Access World Forums

 

[gruntingmonkey]

For a starter use this:

Sub test()


' open IE, navigate to the desired page and loop until fully loaded
    Set IE = CreateObject("InternetExplorer.Application")
    my_url = "http://rd.hemaspharma.com/Pharma/Login.aspx?ReturnUrl=%2fPharma"
   
    With IE
        .Visible = True
        .navigate my_url
        .Top = 5
        .Left = 5
        .Height = 600
        .Width = 900
  
    Do Until Not IE.Busy And IE.readyState = 4
        DoEvents
    Loop

    End With

' Input the userid
    IE.document.getElementById("ASPxRoundPanel1_ctl12_txtUserName").Value = "TestName"
    IE.document.getElementById("ASPxRoundPanel1_ctl12_txtPassword").Value = "TestPW"
' Click the "Next" button
    IE.document.getElementById("ASPxRoundPanel1_ctl12_btnLogin").Click

    Do Until Not IE.Busy And IE.readyState = 4
        DoEvents
    Loop
    
    
End Sub

You will need to put the username and password in. On the next page you will need to look at the HTML code and use the link that vds1 provided to extract the data.

 

[stggst]

Thanks for your reply.

Cant we do it using firefox??