I do this by making the macro an Auto_Open macro (so that it will run when
the workbook is opened), then setting the Excel file to run via a Windows
Scheduled Task. Just be certain that the macro is signed (use selfcert.exe)
and that the signer is trusted; otherwise you'll be stuck looking at a
security warning.
--Bruce

"JB2010" wrote:

howdy


is there a way to program a macro to run automatically at the same time
every day?

i presume it could be triggered by saying when NOW = the user specified time
it begins, but i do not know whether such a thing is possible, or whether i
would have to have the spreadsheet open at that time every day for it to work
etc.

any thoughts gratefully received. if you need more info about what i have
tried to describe, please reply


cheers