VBA task scheduler

[toptech]

Hi There.

I have a table that contains 5 records of files with their locations that I need to email at different times.

I Need to schedual day of the week and time of day.


Does anyone have vba code to this.

Thanks in advance.

Jeff


Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.

 

[SkipVought]

hi,

In Excel,you can use the Application.OnTime method. Use either MS Query or ADO to access your MS Access table.

The workbook containing this code must be running.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[toptech]

Thanks for the info.

I will check it out.

Jeff

Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.