none
Deploying Excel Add-In with Windows Installer - Prerequisites RRS feed

  • Question

  • Hi there!

    I need to deploy an Excel Add-In solution target for .Net Framework 3.5 and both Excel 2007/2010.

    Using Visual Studio 2010 I set the followings prerequisites:

    a) .Net Framework 3.5 SP1

    b) Microsoft Office 2007 PIA

    c) Microsoft Office 2010 PIA

    d) Microsoft Visual Studio 2010 Tools for Office Runtime (x86 and x64)

    e) Windows Installer 3.1

    Here is my question: did I make the right choices, or I missed others prerequisites?

    Another question: after buid the Setup Project, VS warned with the following message:

    "Warning    11    No 'HomeSite' attribute has been provided for 'Microsoft Office 2007 Primary Interop Assemblies', so the package will be published to the same location as the bootstrapper.    E:\ORIC\Development\_Net\Visual Studio\ORIC\LbtMenu3\Setup1\Setup1.vdproj    Setup1

    What does it mean? Should I worry about the message, or I can ignore it?

    Best regards,


    Ciro

    Tuesday, February 28, 2012 1:49 AM

Answers

  • Few problems:

    1. You either code against 2010 PIA or 2007 PIA so installing them both on target machine makes no sense.

    2. VSTO Runtime bitness depends on office bitness on target machine, so you should create 2 separate installers, one for 32 bit and one for 64 bit and in each installer check only matching bitness of this prerequisite.

    And warning tells you only that 2007 PIA will be distributed along with your installer so it adds to size of your package, beside that it should be ok.

    • Marked as answer by Oric.CQ Tuesday, February 28, 2012 6:41 PM
    Tuesday, February 28, 2012 10:23 AM

All replies

  • Few problems:

    1. You either code against 2010 PIA or 2007 PIA so installing them both on target machine makes no sense.

    2. VSTO Runtime bitness depends on office bitness on target machine, so you should create 2 separate installers, one for 32 bit and one for 64 bit and in each installer check only matching bitness of this prerequisite.

    And warning tells you only that 2007 PIA will be distributed along with your installer so it adds to size of your package, beside that it should be ok.

    • Marked as answer by Oric.CQ Tuesday, February 28, 2012 6:41 PM
    Tuesday, February 28, 2012 10:23 AM
  •  Hi  Damian! Thanks to reply!

    About "1. You either code against 2010 PIA or 2007 PIA so installing them both on target machine makes no sense.", what can I do, if I don't know previously if the user will run the Add-in with Excel 2007 or 2010?

    Best regards,


    Ciro

    Tuesday, February 28, 2012 11:59 AM
  • If you write code that uses new functionality available only on 2010 but you are careful enough to detect version of office and invoke those functions only if they exist then you can distribute only 2010 PIA, they should be compatible with 2007 in components available on both versions.

    Otherwise code against 2007 PIA and therefore distribute only them, they will also work on 2010.

    Tuesday, February 28, 2012 12:10 PM
  • Thanks!

    Best regards,


    Ciro

    Tuesday, February 28, 2012 6:42 PM