View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
 
Posts: 173
Default Time Marco issue

Dear Expert,
I want to set certain Excel macros to be run on scheduled time in a day.
This file contains those macros will be saved as add-in file so that
whenever Excel is "On", automated macros will be run on schedule time.
Just wonder how to write the scripts in VB ? Macros have been written
already, but now just need me to click "YES" or "Run" button. It is very
routine and clerical. Hope dear expert here can help me.