Windows Installer Setup Project does not accept output from VSTO Excel add-in project due to supposed architecture mismatch

Question

I am migrating an old Excel add-in from 32 to 64 bits. Orignal source code was lost so I need to repackage VBA files from an old MSI cabinet. I want to build a package (MSI) that contains:

• Updated Excel files from the old plugin (XLAM, XLA and some others)
• New VSTO Excell add-in that will load the VBA modules to Excell on startup.

I have configured a Windows Installer Setup Project to package output from the Add-in.

Problem is that I keep getting this error:

ERROR: File 'VSTOAddIn.dll' of project output 'Primary output from VSTOAddIn (Active)' targeting 'AMD64' is not compatible with the project's target platform 'x86'.

I have set any drop down with architecture I found in both project configuration to "x64". In the build manager it seems like the Installer Setup Project is architecture agnostic:

Am I missing somthing or my approach is wrong alltogether?

Tested with Visual Studio Community 2019 and 2022

Answer 1

In the property pane for the setup project try setting the TargetPlatform property to x64.