Getting around Excel Macro notifications in AD
 

I hope someone has had to deal with this before, regardless, any suggestions
are much appreciated

Overview: AD GPO resets macro security level from low to medium

Problem: for automated macros (excel files with macros) to run on a
schedule, can't require user input (don't want to click on "Enable" to run
it when its automated)

Solutions: Purchase an external application (any suggestions here) that can
mimic user clicking on Enable as soon as Excel opens

Preferred Solution: Program it, via Excel Macro or VB (have to have a
service type app running all the time reading process ID and name, once it
detects Excel, have it click on Enable -- now only if I was a decent coder)

Note: Changing the GPO is not an option

If anyone has code that tracks process name, or that can mimic clicking on
windows or such, much appreciated

Mike

Getting around Excel Macro notifications in AD
 

AutoIt does the mouse clicks you need.
http://www.hiddensoft.com/AutoIt/

But I suggest you look into the "Trusted Sources" options.
You can sign your code so it becomes trusted.
http://msdn.microsoft.com/library/en...olut ions.asp
http://www.microsoft.com/technet/col...n/5min-402.asp


Rob


"Mike Canmore" wrote in message
...
I hope someone has had to deal with this before, regardless, any
suggestions
are much appreciated

Overview: AD GPO resets macro security level from low to medium

Problem: for automated macros (excel files with macros) to run on a
schedule, can't require user input (don't want to click on "Enable" to run
it when its automated)

Solutions: Purchase an external application (any suggestions here) that
can
mimic user clicking on Enable as soon as Excel opens

Preferred Solution: Program it, via Excel Macro or VB (have to have a
service type app running all the time reading process ID and name, once it
detects Excel, have it click on Enable -- now only if I was a decent
coder)

Note: Changing the GPO is not an option

If anyone has code that tracks process name, or that can mimic clicking on
windows or such, much appreciated

Mike