Excel VSTO Template project type in Visual Studio problem with libray reference generated in VBA "Tools/RefereVnces" RRS feed

  • Question

  • when the project automatically generates the path to the Excel document (.xltm) customisation library it displays in the VBA included libraries as "MISSING" using the following path ...\PMSExcelView\bin\debug\PMSExcelView.dll#PMSExcelView. If I load PMSExcelView.dll manually at this stage VBA recognises the libary and everything works. I have then saved the updated document under the 'PMSExcelView' project. But as soon as the document is reopened/restarted it has reinitialised back to the MISSING and incorrect reference which includes the suffix "#PMSExcelView". Why is this added to the correct path to the selected .dll?
    Friday, July 19, 2019 4:30 PM

All replies