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??
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??