When excel opens, it opens any files found in the xlstart directory. One
such file is personal.xls if you have created one by recording a macro and
selecting to save it in your personal file. You can put code in the
workbook_open event of this workbook to setup the ontime event.
See Chip Pearson's site on using Ontime:
http://www.cpearson.com/excel/ontime.htm
--
Regards,
Tom Ogilvy
"tina" wrote in message
...
I would like to know how to open a named workbook when excel opens so I
can run a macro .I have wriiten private sub workbook_open macro and put this
in this workbook for file dddstocks I need this file to run at 3.00am
everyday automatically
any help or pointers where to find good help would be much appreciated
Thanks
Tina