View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RW RW is offline
external usenet poster
 
Posts: 49
Default OLE and excel on Windows 2003 server

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 Im
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