none
Excel Add-In not loading when Excel is launched by VBScript RRS feed

  • Question

  • Hi all,

    Issue is as follows.  If I launch Excel normally, my AddIn loads and behaves normally.  When launching Excel via VBScript (eg: CreateObject("Excel.Application")), as we do thru our web app, the AddIn does not load.  If I go and look at the AddIns setup in Excel, the AddIn appears enabled under Com AddIns and is not listed under Disabled AddIns.  If I uncheck and re-check the AddIn under Com AddIns, it works fine.  I tried adding the location of the spreadsheet we are opening to Trusted Locations, no effect.  Also tried diabling antivirus, also no effect.

    Tried also enabling the VSTO error message and log file environment variables, no messages are shown.

    This is especially confusing since this whole setup used to work.  Something has changed obviously, maybe a Windows security update.  Any ideas on how to diagnose?

    Thanks,

    Jonathan

    Friday, March 1, 2013 8:08 PM

Answers

All replies