SAVE TABLES AUTO INTO EXCELL EVERYDAY W/DIFF NAMES

D

deb51

i need to write code to be able to back up tables from an access database
into excell everyday with a different excell file name assigned to the file.
i know how to do the macro but that route assigns the same name everyday and
asks if you want to replace it. maybe we just rename the file. just
thinking out loud. some one please help. thanks Deb
 
Top