Is there a way to program a workbook to perform a
procedure without having to open the workbook?

We have a spreadsheet that contains a column of
expiration dates in ascending order. We would like to
send a group e-mail that notifies staff of an expiration
date(s) one week in advance.

I've been playing around with initializing the Excel
application in a class module and the hasroutingslip
property but all the research I've done seems to require
that the workbook be open.