PDA

View Full Version : Downlaod URL Data on disk based on criteria



parth007
01-05-2015, 07:08 AM
Need VBA to do following task... Bit Urgent
One Excel sheet have URL data as attached
Need to create a button which will do below activty
1) Open URL specified which is written in cell ("B1")
2) Enter UserID, UserName & password written in cells ("B2"), ("B3"), ("B4") in the URL which is in ("A1")
3) Select certain parameters & then run the report on URL & download the data in PDF format on disk..
Note - The URL given in B1 is test.. i dont know if there is any other such testing url from where we can download data on conditions

Is it possible that above will be done on CommandButton1.click??