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.

Hi Lesa,

I'm not sure exactly what you're looking for, but you could try using ADO to
retrieve the values from the Workbook. If you do a search from
http://groups.google.com/ on "closed workbook" and "ado", you should find
some helpful information.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Lesa wrote:
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.