Honestly, you would be better off creating a scheduled task in Windows to
launch Excel with a named workbook, and have an Auto_Open macro to do what
you need.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"buzzharley" wrote
in message ...

I'm so lost!! I've been trying all night long to just get a macro to
run once everyday! Do I need to enter something like repeat the ontime
in the Macro that I have the ontime running so It keeps running
everyday?

Is there a special way to start running the ontime- I've read to save
it then reopen the workbook, the run the macro? I have been trying to
go into the future by advancing a day in the calander of my computer.
It will work once and then it won't work again the next day!!


--
buzzharley
------------------------------------------------------------------------
buzzharley's Profile:
http://www.excelforum.com/member.php...o&userid=35886
View this thread: http://www.excelforum.com/showthread...hreadid=558403