Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Daily Macro Triggering
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 |
#3
|
|||
|
|||
Daily Macro Triggering
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro Help | Excel Worksheet Functions | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |