Thread: Daily Macro Triggering

howdy


is there a way to program a macro to run automatically at the same time
every day?

i presume it could be triggered by saying when NOW = the user specified time
it begins, but i do not know whether such a thing is possible, or whether i
would have to have the spreadsheet open at that time every day for it to work
etc.

any thoughts gratefully received. if you need more info about what i have
tried to describe, please reply


cheers

I do this by making the macro an Auto_Open macro (so that it will run when
the workbook is opened), then setting the Excel file to run via a Windows
Scheduled Task. Just be certain that the macro is signed (use selfcert.exe)
and that the signer is trusted; otherwise you'll be stuck looking at a
security warning.
--Bruce

"JB2010" wrote:

> howdy
>
>
> is there a way to program a macro to run automatically at the same time
> every day?
>
> i presume it could be triggered by saying when NOW = the user specified time
> it begins, but i do not know whether such a thing is possible, or whether i
> would have to have the spreadsheet open at that time every day for it to work
> etc.
>
> any thoughts gratefully received. if you need more info about what i have
> tried to describe, please reply
>
>
> cheers

Bruce

that is wizard

cheers pal

jb

"bpeltzer" wrote:

> I do this by making the macro an Auto_Open macro (so that it will run when
> the workbook is opened), then setting the Excel file to run via a Windows
> Scheduled Task. Just be certain that the macro is signed (use selfcert.exe)
> and that the signer is trusted; otherwise you'll be stuck looking at a
> security warning.
> --Bruce
>
> "JB2010" wrote:
>
> > howdy
> >
> >
> > is there a way to program a macro to run automatically at the same time
> > every day?
> >
> > i presume it could be triggered by saying when NOW = the user specified time
> > it begins, but i do not know whether such a thing is possible, or whether i
> > would have to have the spreadsheet open at that time every day for it to work
> > etc.
> >
> > any thoughts gratefully received. if you need more info about what i have
> > tried to describe, please reply
> >
> >
> > cheers

Bruce

that is wizard

cheers pal

jb

"bpeltzer" wrote:

> I do this by making the macro an Auto_Open macro (so that it will run when
> the workbook is opened), then setting the Excel file to run via a Windows
> Scheduled Task. Just be certain that the macro is signed (use selfcert.exe)
> and that the signer is trusted; otherwise you'll be stuck looking at a
> security warning.
> --Bruce
>
> "JB2010" wrote:
>
> > howdy
> >
> >
> > is there a way to program a macro to run automatically at the same time
> > every day?
> >
> > i presume it could be triggered by saying when NOW = the user specified time
> > it begins, but i do not know whether such a thing is possible, or whether i
> > would have to have the spreadsheet open at that time every day for it to work
> > etc.
> >
> > any thoughts gratefully received. if you need more info about what i have
> > tried to describe, please reply
> >
> >
> > cheers