Opening an Excel file from Explorer (by the double click) invokes DDE.
Your ERP app uses COM.

Not sure of the user/server/admin settings, but COM+/DCOM config may be
somewhere to look.

NickHK

"RW" wrote in message
...
I have following issue with excel macros and (what I believe) Windows 2003
server local security. regardless if I setup macro security to "low" or
create locally cert and sign macro VB code with it I have no problem
opening
this excel workbook locally on server by double clicking on excel template
file stored locally on server, but if I try to launch same excel file thru
OLE triggered by ERP application task "on event" (having still VB code
sign
or macros security set to low) I get message saying that macro is set to
high,sign as trusted ??? some how windows "knows" that another application
is
trying to open this excel workbook and does not allow macros eventhough it
is
signed and set to be trusted, does any know how to fix that? Reason I'm
thinking this is due to windows 2003 security is because same excel
workbook
work perfectly fine on W2k server, before we migrated ERP app to newer
hardwar and windows 2003 OS

Tia