Macro to generate auto daily files with todays Birthday

[dingdang]

I have customer data having date of birth in column( dd-mm-yyyy ) G, required macro to which generate auto daily file at 9.00 am with todays birthday in purticular folder with file name : todays birthday - dd-mm-yyyy in c:\data.

[dingdang]

any solution ??