Notify without opening workbook

L

Lesa

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.
 
J

Jake Marx

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]
 
Top