Automatic download a table from website with multiple user IDs and passwords

[gajjarvishal86]

Hi,

Is it possible for me use VBA to download specific data from page with login ID and password.

Let us say i want to automate macro to collect the college result of 10 students from one website which is in table. This page can only be open by user ID and password.

I have user ID and password of 10 students. Is it possible for me to design macro in VBA which can automatically login on a page collect the data from result table and put it in a sheet.

Please suggest.

Regards,
Vishal

 

[Marc L]

Hi,

should be possible with QueryTable VBA object …
​