PDA

View Full Version : Solved: scheduled task question



vzachin
11-28-2010, 10:19 AM
hi,

i have a scheduled task opening an excel file to run a macro, but i'm running into a problem. When the file opens, it stops at the Security Warning Screen, "Disable Macro", "Enable Macro". and stays there until the scheduled task time expires.

how can i get past this warning? without me clicking on "Enable Macro" manually?




thanks
zach

shrivallabha
11-28-2010, 10:23 AM
Set the Security To "Low" (which is currently "Medium") in Tools>>Macros>>Security. However, setting it to Low is NOT a recommended option.

vzachin
11-28-2010, 11:21 AM
hi Shrivallabha, thanks for the reply, and you are correct in stating that setting the Security to Low is NOT recommended. i need a different method.

zach

Bob Phillips
11-28-2010, 11:39 AM
Put it in an addin.

vzachin
11-28-2010, 02:45 PM
hi bob,
i will google and see if i can figure out how to place the code in an addin,
unless you can give me a quick pointer :-)

thanks
zach

Sean.DiSanti
11-29-2010, 04:19 PM
if this only needs to run on ONE machine; you could use the SelfCert.exe (in your office folder) to create a certificate that you could trust on that machine. Then add that to your trusted sources (will only work on the machine it's created on) and you won't be prompted for those macros

vzachin
11-30-2010, 07:48 PM
sean,thanks for the tip. works great. this script only needs to run on my pc

zach

Sean.DiSanti
12-03-2010, 01:01 PM
no problem, glad to help