Excel code must be hosted in an open workbook to run. Either that book or
another.

the workbook_open event in the thisworkbook module can be used to fire code
when the workbook is opened and the user does not disable macros.

the steps I described can be done with a macro and the code can be obtained
by using the macro recorder while you perform the actions one time manually.

http://www.cpearson.com/excel/events.htm

You can access an excel workbook as a database

http://www.erlandsendata.no/english/...php?t=envbadac

so this can be done from any application/programming language that supports
using ADO.

--
Regards,
Tom Ogilvy


"fee" wrote:

Thanks Tom

But I would like it more automatted than that so that when you open it.
It produces what is to be checked that day automatically, sorry never
explained that to well. Or if possible could it produce the list
without opeing the spreadsheet, like a work to list.