NileshAPatel
New Member
- Joined
- May 29, 2021
- Messages
- 26
- Office Version
- 365
- 2019
- Platform
- Windows
Hi,
Thanks in advance...
After login to url with ID and Password
I needs VBA coding to click 5 link on excel file which open url in new tab and starts downloading file.
Once files get downloaded need to save it in folder "D:\Raw Data\"
1st file get downloaded thereafter open second link and on
Thanks in advance...
After login to url with ID and Password
I needs VBA coding to click 5 link on excel file which open url in new tab and starts downloading file.
Once files get downloaded need to save it in folder "D:\Raw Data\"
1st file get downloaded thereafter open second link and on
File Name | URL to open in new tab start downloading |
CustomerOrderReport.xls | Dealership Management System |
PendingOrderReport.xls | Dealership Management System |
StockInHandReport.xls | http://kiranmaruti.infoman-edms.com/Reports/pgTstockInHandReport.aspx?&LocationId=0&Location=&AsOnDate=05/13/2022&SupplierCat=A&Supplier=0&Make=0&ProductCat=0&Model=0&SubModel=0&Color=0&QAStatus=3,1,2&VehStatus=^F^,^A^,^L^&StockLocation=0&INFFin=0&HOLoginTag=Y&LoginId=3233&DealerName=KIRAN%20MOTORS%20LIMITED%20&FileFormat=xls&CheckVStatus=N&CTag=C&strAssignedLocTag=Y&AssLocId=0 |
SalesRegisterReport.xls | http://kiranmaruti.infoman-edms.com...rInc=N&IncAccBreakUp=N&AccTaxTag=N&SortBy=All |
InvoicedNotDeliveredReport.xls | Dealership Management System |
Test.xlsb | ||||
---|---|---|---|---|
A | B | |||
2 | File Name | URL to open in new tab start downloading | ||
3 | CustomerOrderReport.xls | Dealership Management System | ||
4 | PendingOrderReport.xls | Dealership Management System | ||
5 | StockInHandReport.xls | http://kiranmaruti.infoman-edms.com/Reports/pgTstockInHandReport.aspx?&LocationId=0&Location=&AsOnDate=05/13/2022&SupplierCat=A&Supplier=0&Make=0&ProductCat=0&Model=0&SubModel=0&Color=0&QAStatus=3,1,2&VehStatus=^F^,^A^,^L^&StockLocation=0&INFFin=0&HOLoginTag=Y&LoginId=3233&DealerName=KIRAN%20MOTORS%20LIMITED%20&FileFormat=xls&CheckVStatus=N&CTag=C&strAssignedLocTag=Y&AssLocId=0 | ||
6 | SalesRegisterReport.xls | http://kiranmaruti.infoman-edms.com...rInc=N&IncAccBreakUp=N&AccTaxTag=N&SortBy=All | ||
7 | InvoicedNotDeliveredReport.xls | Dealership Management System | ||
Sheet2 |