I'm a little confused, so a few questions..
1. is your HR Database done with Access?
2. do you want to create a new .xls file each day?
3. -- or just a new worksheet in the same workbook?
4. -- or just constantly update the same worksheet?
5. I don't understand "update prev day's xls with..."