Need to download .DAT file from web via excel 2010.
Step 1 Put start date & End Date
Step 2 (a) Macro run – if data is available for that date then download to new sheet & then create new workbook for that particular sheet with date as its name.
Step 2 (b) Macro Run – if data is not available then go for next date.
Step 3 downloading data for next date.
As downloadable link is this…
where 04012013 is date (ddmmyyyy). So if we replace that with different date data will appear for that date.
Please Help Me Out In This.