View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Running Excel macro as a service

hi
thomas has a good idea but just to give another option, you might try
looking at the ontime event in excel.
see this site for more details.
http://www.cpearson.com/excel/OnTime.aspx

Regards
FSt1

"Yan" wrote:

Hello,

I need to run an Excel (2003) macro as a service. Every day at 2 pm to copy
data from one worksheet to another.

I alredy have written a macro but how do I set it to run everyday at 2 PM ?

Thanks

Yan