Schedule macro within Excel

  • Thread starter Thread starter Mark Frank
  • Start date Start date
M

Mark Frank

Hi all,

Does anyone have an example of an Excel macro whereby a
workbook opens on a scheduled basis? I know this is a
little odd, but, because Excel does not install add-ins
when opened by creating an application object from outside
Excel, I am hoping to work off the system clock within the
program.

Thanks,

Mark
 
Is not odd at all ... I have a number of ss that run every Monday morning
distributing work. I use task scheduler for this little feat. I'm using
Win2000 os (the only draw back is having to change the password when
changing system password) but otherwise the task scheduler opens excel, runs
the macro steps, sends an email and closes. The only hint I know it worked
is to review my sent items.
 
Back
Top