Addin problem

[boopesh]

we have a application which creates some add-ins in
toolbar, when installed using setup.exe

We are trying to create .MSI file, after which the
application installs sucessfully but the addin doesn't
work it reads Error the blpmain.xla contains macro,
macro's may contain virus.

Following script is used to add Excel add-ins

Option Explicit
On Error Resume Next

' Define constants.
Const ADDIN = "C:\Program Files\blp\API\dde\BlpMain.xla"

' Load the add-ins into excel.
Dim objXL, objAddIn
Set objXL = CreateObject("Excel.Application")
objXL.Workbooks.Add
Set objAddIn = objXL.AddIns.Add(ADDIN, true)
objAddIn.Installed = true
objXL.Quit

 

[Robin Hammond]

Sounds like a bloomberg dde link! I'm say it's your Excel security settings,
which cannot be changed from VB or VBA. They are probably set to medium
under Tools, Options, Security, Macro Security.

Change it to low once to see whether the message disappear, then change it
back. It's what your customers should be doing anyway.

HTH,

Robin Hammond
www.enhanceddatasystems.com