I have a VB6 application that stores data in an excel spreadsheet first and then into a remote mySQL database.

I save to Excel because of its graphs capabilities (I have my application print an excel spreadsheet once the data is entered into it), and because I think it would be a nice backup file for my application (in case the server is down or the internet connection is dropped temporarily). All data entries are saved on a separate spreadsheet within my workbook.

The program is on a computer that I do not have access to all the time, so I would like the excel workbook to be emailed to me when I want it.

It would be nice to have it automatically email me once a week (I assume this is the most efficient way of doing this).

I can email using CDO without any problems, but I don't know how to set this up to email every 7 days, for instance. I do have a timer on my main form that will update two labels with the current date and time. The timer's interval is set to 1.

Any tips or advice?

Maybe there is an easier way of doing this also, that I am not aware of, to get access to my excel file whenever I want it.