View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jswalsh33 jswalsh33 is offline
external usenet poster
 
Posts: 51
Default Run a Macro at a certain time

I have tried to use Mike H's answer to Running Excel macro as a service
dated 9/30/2008.

I have us the task Scheduler to open the Excel Workbook containing the macro
I want to run with a time of 2:00 AM.

When I put the code Application.OnTime TimeValue("02:01:00"), "Merge" as the
first line of the Macro Merge, nothing happens when 02:01:00 comes.

What am I doing wrong?

Jim Walsh