Macro that sends email automatically once a week?

[GTfan]

Ok so I created a macro using code that I found online to convert a spreadsheet into a PDF and send it to an email address.

Now, I was wondering if anybody knew a way that I could program this macro to automatically do this once a week at a specific time without user interface?

Here is my function for creating a PDF:

Please Login or Register  to view this content.

Sending Email:

Please Login or Register  to view this content.

And here is the sub that calls the functions:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Do any of these help?

http://www.cpearson.com/excel/OnTime.aspx

http://www.globaliconnect.com/excel/...=79&Itemid=475