Warning when opening Excel with intellisense

[samjameswilliams]

Hi,

I’ve got a project which is working fine except I get the message below when I open Excel. I’m not trying to package intellisense into my project .xll. I’m perfectly happy to use the intellisense.xll. I’ve installed both my project xll with UDFs which I’ve decorated for intellisense and I’ve installed the intellisense xll. Once I dismiss the warning everything works as it should, the udfs are fine and the intellisense pops up just like I want. Can someone please let me know how to make the warning not pop up?

Warning when starting Excel

Initialization [Warning] Assembly EXCELDNA.INTELLISENSE could not be loaded from resources.
Initialization [Error] DnaLibrary AutoOpen Invoke Error : FileNotFoundException - Could not load file or assembly 'ExcelDna.IntelliSense, Version=1.1.0.0, Culture=neutral, PublicKeyToken=f225e9659857edbe' or one of its dependencies. The system cannot find the file specified.

Excel_DNA_project.vbproj

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <RootNamespace>Excel_DNA_project</RootNamespace>
    <TargetFramework>net48</TargetFramework>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="ExcelDna.Addin" Version="*-*" />
    <PackageReference Include="ExcelDna.IntelliSense" Version="*-*" />
  </ItemGroup>

  <ItemGroup>
    <Compile Update="My Project\Settings.Designer.vb">
      <DesignTimeSharedInput>True</DesignTimeSharedInput>
      <AutoGen>True</AutoGen>
      <DependentUpon>Settings.settings</DependentUpon>
    </Compile>
  </ItemGroup>

  <ItemGroup>
    <None Update="My Project\Settings.settings">
      <CustomToolNamespace>My</CustomToolNamespace>
      <Generator>SettingsSingleFileGenerator</Generator>
      <LastGenOutput>Settings.Designer.vb</LastGenOutput>
    </None>
  </ItemGroup>

</Project>

intellisense.vb

Imports ExcelDna.Integration
Imports ExcelDna.IntelliSense

Public Class IntelliSenseAddIn
    Implements IExcelAddIn

    Public Sub AutoOpen() Implements IExcelAddIn.AutoOpen
        IntelliSenseServer.Install()
    End Sub

    Public Sub AutoClose() Implements IExcelAddIn.AutoClose
        IntelliSenseServer.Uninstall()
    End Sub
End Class

I’m not a .NET developer and don’t even know VBA. I do Python mostly, so please don’t assume much knowledge.

Thank you for Excel-DNA it’s a great tool

[samjameswilliams]

I think I can see what I’ve done wrong. I’ve just tried re compiling the xll having commented out the intellisense.vb file. It built fine and when I started up Excel there was no warning any more. So I think (please correct me if I’m wrong) the intellisense.vb code is only necessary if you want to package up intellisense in a single xll (which I’m not trying to do, I’m trying to go with the recommended approach of using the pre-compiled intellisense xll). So the error came from me doing that incorrectly, but it still worked because I had the intellisense xll installed.