none
Excel Addin - ClickOnce Post-deployment action cannot be found RRS feed

  • Question


  • I have an Excel addin that is deployed and updated by clickonce.  There are some supporting files that files that I need for the addin (templates, .xlam, etc.) and I use a Post-Deployment procedure to copy those files to the correct location.

    After mucking about with an unrelated problem, I screwed up the deployment procedure and now it errors out whenever I attempt to Install/or update the app, stating that the post deployment file cannot be found:

    Name: PwC Analytics Toolbar
    From: file:///H:/4_Resources/Modelling Toolbar/ModellingToolbar.vsto
    
    ************** Exception Text **************
    Microsoft.VisualStudio.Tools.Applications.Deployment.InstallAddInFailedException: The following assembly for a post-deployment action cannot be found: "FileCopyPDA, Version=1.0.0.0, Culture=neutral, ProcessorArchitecture=msil".
       at Microsoft.VisualStudio.Tools.Applications.Deployment.PostDeploymentActionsHost.Execute(Int32& lastExecutedPostAction, Uri deployManifestUri, AddInInstallationStatus installStatus, String deployManifestXml, String appManifestXml, String hostManifestXml, String[] postActionDataXmls, String productName, String version, String applicationBase, String[] assemblyClassNames, String[] assemblyNames, String[] assemblyFullNames)
       at Microsoft.VisualStudio.Tools.Applications.Deployment.PostDeploymentActionsHost.Execute(Int32& lastExecutedPostAction, Uri deployManifestUri, AddInInstallationStatus installStatus, String deployManifestXml, String appManifestXml, String hostManifestXml, String[] postActionDataXmls, String productName, String version, String applicationBase, String[] assemblyClassNames, String[] assemblyNames, String[] assemblyFullNames)
       at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InvokePostActions(Uri deploymentUri, AddInInstallationStatus installStatus, String deployManifestXml, String appManifestXml, ApplicationManifest manifest, String productName, String version, AppDomainSetup appDomainSetup)
       at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()
       at Microsoft.VisualStudio.Tools.Office.Runtime.SolutionInstaller.<>c__DisplayClass7.<Install>b__0()

    The library clearly exists in the correct location:

    I have updated the manifest to include the post deployment routine:

    <?xml version="1.0" encoding="utf-8"?>
    <asmv1:assembly xsi:schemaLocation="urn:schemas-microsoft-com:asm.v1 assembly.adaptive.xsd" manifestVersion="1.0" xmlns:asmv1="urn:schemas-microsoft-com:asm.v1" xmlns="urn:schemas-microsoft-com:asm.v2" xmlns:asmv2="urn:schemas-microsoft-com:asm.v2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:co.v1="urn:schemas-microsoft-com:clickonce.v1" xmlns:asmv3="urn:schemas-microsoft-com:asm.v3" xmlns:dsig="http://www.w3.org/2000/09/xmldsig#" xmlns:co.v2="urn:schemas-microsoft-com:clickonce.v2">
      <asmv1:assemblyIdentity name="ModellingToolbar.dll" version="0.8.2.36" publicKeyToken="62c614bc780ff547" language="neutral" processorArchitecture="msil" type="win32" />
      <description xmlns="urn:schemas-microsoft-com:asm.v1">ModellingToolbar</description>
      <application />
      <entryPoint>
        <co.v1:customHostSpecified />
      </entryPoint>
      <trustInfo>
        <security>
          <applicationRequestMinimum>
            <PermissionSet Unrestricted="true" ID="Custom" SameSite="site" />
            <defaultAssemblyRequest permissionSetReference="Custom" />
          </applicationRequestMinimum>
          <requestedPrivileges xmlns="urn:schemas-microsoft-com:asm.v3">
            <!--
              UAC Manifest Options
              If you want to change the Windows User Account Control level replace the 
              requestedExecutionLevel node with one of the following.
    
            <requestedExecutionLevel  level="asInvoker" uiAccess="false" />
            <requestedExecutionLevel  level="requireAdministrator" uiAccess="false" />
            <requestedExecutionLevel  level="highestAvailable" uiAccess="false" />
    
             If you want to utilize File and Registry Virtualization for backward 
             compatibility then delete the requestedExecutionLevel node.
        -->
            <requestedExecutionLevel level="asInvoker" uiAccess="false" />
          </requestedPrivileges>
        </security>
      </trustInfo>
      <dependency>
        <dependentOS>
          <osVersionInfo>
            <os majorVersion="5" minorVersion="1" buildNumber="2600" servicePackMajor="0" />
          </osVersionInfo>
        </dependentOS>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.Windows.CommonLanguageRuntime" version="4.0.30319.0" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.Office.Tools" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.Office.Tools.Common" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.Office.Tools.Excel" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.Office.Tools.v4.0.Framework" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.VisualStudio.Tools.Applications.Runtime" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="stdole" version="7.0.3300.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="FileCopyPDA.dll" size="14848">
          <assemblyIdentity name="FileCopyPDA" version="1.0.0.0" language="neutral" processorArchitecture="msil" />
          <hash>
            <dsig:Transforms>
              <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
            </dsig:Transforms>
            <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
            <dsig:DigestValue>1M/Gb+dT4e7kH1jJZBx0rTWPS64=</dsig:DigestValue>
          </hash>
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="Microsoft.Office.Tools.Common.v4.0.Utilities.dll" size="32664">
          <assemblyIdentity name="Microsoft.Office.Tools.Common.v4.0.Utilities" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
          <hash>
            <dsig:Transforms>
              <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
            </dsig:Transforms>
            <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
            <dsig:DigestValue>CtnCtseaMyfROIGe0ENdGO6arHg=</dsig:DigestValue>
          </hash>
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="ModellingToolbar.dll" size="211968">
          <assemblyIdentity name="ModellingToolbar" version="1.0.0.0" language="neutral" processorArchitecture="msil" />
          <hash>
            <dsig:Transforms>
              <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
            </dsig:Transforms>
            <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
            <dsig:DigestValue>cnK0qN+IfRY+e6zF61Xal3JVguY=</dsig:DigestValue>
          </hash>
        </dependentAssembly>
      </dependency>
      <file name="Data\Analytics VBA.xlam" size="483169">
        <hash>
          <dsig:Transforms>
            <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
          </dsig:Transforms>
          <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
          <dsig:DigestValue>uyz3vgCL4Et5AIyCaVJ4m86ovl4=</dsig:DigestValue>
        </hash>
      </file>
      <file name="Data\Table Library.xlsx" size="40619">
        <hash>
          <dsig:Transforms>
            <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
          </dsig:Transforms>
          <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
          <dsig:DigestValue>uuqAOxczZml8Izm/RXtPhBuMhO4=</dsig:DigestValue>
        </hash>
      </file>
      <file name="ModellingToolbar.dll.config" size="2035">
        <hash>
          <dsig:Transforms>
            <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
          </dsig:Transforms>
          <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
          <dsig:DigestValue>mLXELhKdDKTy6lHpMDKThMfGV8o=</dsig:DigestValue>
        </hash>
      </file>
      <vstav3:addIn xmlns:vstav3="urn:schemas-microsoft-com:vsta.v3">
        <vstav3:entryPointsCollection>
          <vstav3:entryPoints>
            <vstav3:entryPoint class="AnalyticsToolbar.ThisAddIn">
              <assemblyIdentity name="ModellingToolbar" version="1.0.0.0" language="neutral" processorArchitecture="msil" />
            </vstav3:entryPoint>
          </vstav3:entryPoints>
        </vstav3:entryPointsCollection>
        <vstav3:update enabled="true" />
        <vstav3:postActions>
          <vstav3:postAction>
            <vstav3:entryPoint class="FileCopyPDA.FileCopyPDA">
              <assemblyIdentity name="FileCopyPDA" version="1.0.0.0" language="neutral" processorArchitecture="msil" />
            </vstav3:entryPoint>
            <vstav3:postActionData>
            </vstav3:postActionData>
          </vstav3:postAction>
        </vstav3:postActions>
        <vstav3:application>
          <vstov4:customizations xmlns:vstov4="urn:schemas-microsoft-com:vsto.v4">
            <vstov4:customization>
              <vstov4:appAddIn application="Excel" loadBehavior="3" keyName="ModellingToolbar">
                <vstov4:friendlyName>AnalyticsToolbar</vstov4:friendlyName>
                <vstov4:description>ModellingToolbar</vstov4:description>
                <vstov4.1:ribbonTypes xmlns:vstov4.1="urn:schemas-microsoft-com:vsto.v4.1">
                  <vstov4.1:ribbonType name="AnalyticsToolbar.AnalyticsToolbar, ModellingToolbar, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
                </vstov4.1:ribbonTypes>
              </vstov4:appAddIn>
            </vstov4:customization>
          </vstov4:customizations>
        </vstav3:application>
      </vstav3:addIn>
    <publisherIdentity name="CN=PWCAU\Carl Gabel" issuerKeyHash="44fc7b7d4e21f7f9cc5d017925abeb59f4a78bc2" /><Signature Id="StrongNameSignature" xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1" /><Reference URI=""><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature" /><Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /><DigestValue>opzHoPo7dXCZr6V377pR04PKyUE=</DigestValue></Reference></SignedInfo><SignatureValue>gNkVsa1lwvv6QxPQoTa/YumEQ2SfUxuqFC6DzavZCsaythQCVyaWJyOvWx23JbaVbufX1gBm/GlaMLCvBLbQH6tsg3jCXSJdOeVrjL5mctOdG8qHC7bR/lmBvxxA4ZEiA3gl+pdygPa8kVpxHtH2piCplNj5UaM2/hfKbnPyAlM=</SignatureValue><KeyInfo Id="StrongNameKeyInfo"><KeyValue><RSAKeyValue><Modulus>xIizsL+NiItZvTDRLA2vitpQk6l9QBY0VUPMgm0bX0tvxNeskK2oW4b5SjGLVKG8I0g7thcRSWAYpgnjt3KSCYjZ613LNRsyUr3mZtaWt2G0RyvfaJR7X9rlD16ucCcr3sl5VBg29nBAxzhCD3jDGV++1Lan7AAQsmKWE3Jpff0=</Modulus><Exponent>AQAB</Exponent></RSAKeyValue></KeyValue><msrel:RelData xmlns:msrel="http://schemas.microsoft.com/windows/rel/2005/reldata"><r:license xmlns:r="urn:mpeg:mpeg21:2003:01-REL-R-NS" xmlns:as="http://schemas.microsoft.com/windows/pki/2005/Authenticode"><r:grant><as:ManifestInformation Hash="41c9ca83d351baef77a5af9970753bfaa0c79ca2" Description="" Url=""><as:assemblyIdentity name="ModellingToolbar.dll" version="0.8.2.36" publicKeyToken="62c614bc780ff547" language="neutral" processorArchitecture="msil" type="win32" /></as:ManifestInformation><as:SignedBy /><as:AuthenticodePublisher><as:X509SubjectName>CN=PWCAU\Carl Gabel</as:X509SubjectName></as:AuthenticodePublisher></r:grant><r:issuer><Signature Id="AuthenticodeSignature" xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1" /><Reference URI=""><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature" /><Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /><DigestValue>2xMGBuysB39GSTThonM9Ybf3vw8=</DigestValue></Reference></SignedInfo><SignatureValue>ugsaiD7DK5KgULmz7xQSSQhWVo1kmnxXPAar6XBRiqGs6kkSaiNAcDLIp9e59jRj5fLrPIldPVXVd5PFbYLGCP+wxt9NF3CmG3PUoMt6jAqQrIFczQfAxbQGBLatPgqs0qJyIJHP9IcqzDwc5odQWEkm6L4oD/eO13L3gbLpwME=</SignatureValue><KeyInfo><KeyValue><RSAKeyValue><Modulus>xIizsL+NiItZvTDRLA2vitpQk6l9QBY0VUPMgm0bX0tvxNeskK2oW4b5SjGLVKG8I0g7thcRSWAYpgnjt3KSCYjZ613LNRsyUr3mZtaWt2G0RyvfaJR7X9rlD16ucCcr3sl5VBg29nBAxzhCD3jDGV++1Lan7AAQsmKWE3Jpff0=</Modulus><Exponent>AQAB</Exponent></RSAKeyValue></KeyValue><X509Data><X509Certificate>MIIB2TCCAUKgAwIBAgIQF2tBiDEQk59Hb2/VpAmPszANBgkqhkiG9w0BAQUFADArMSkwJwYDVQQDHiAAUABXAEMAQQBVAFwAQwBhAHIAbAAgAEcAYQBiAGUAbDAeFw0xMzAyMTMyMzM4NTNaFw0xNDAyMTQwNTM4NTNaMCsxKTAnBgNVBAMeIABQAFcAQwBBAFUAXABDAGEAcgBsACAARwBhAGIAZQBsMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDEiLOwv42Ii1m9MNEsDa+K2lCTqX1AFjRVQ8yCbRtfS2/E16yQrahbhvlKMYtUobwjSDu2FxFJYBimCeO3cpIJiNnrXcs1GzJSveZm1pa3YbRHK99olHtf2uUPXq5wJyveyXlUGDb2cEDHOEIPeMMZX77UtqfsABCyYpYTcml9/QIDAQABMA0GCSqGSIb3DQEBBQUAA4GBADCjJbyqFb8aoolbfMrWqO7Gad8VG4Wz1hFgRvdSUXfOB4L6qQ5HO+XRgI3cqIeYWWrdJkHEUcFGXGAbhfFB8Tvrfsw7G1y5XHY6gqDEniT19WtIVuhlKFh3RAegE8cHUnUF1SQMJmaA1FVvPwDpb+3U6kphBw0Wv9MaNFnxxGDC</X509Certificate></X509Data></KeyInfo></Signature></r:issuer></r:license></msrel:RelData></KeyInfo></Signature></asmv1:assembly>
    

    And I have signed the manifest as described in the walkthrough.  This was working I'm just not sure what I've done to break it.

    Tuesday, April 2, 2013 8:46 AM

All replies

  • Hi QuinRiva,

    Thank you for posting in the MSDN Forum.

    I'll consult my colleague on your issue. You'll be informed if there's any update.

    Thank you for your patience and understanding.

    Best regards,


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, April 4, 2013 12:58 PM
    Moderator
  • Did you publish the solution to mapped network drive H:? Please double check if the drive connects while you install the solution. H:/4_Resources/Modelling Toolbar/ModellingToolbar.vsto

    I also followed up the article and get it working without a problem. It's VS 2010 SP1 + Office 2010 on my side. I assume it's same configuration on your side. Remember, we have to resign the (*.manifest) and update (*.vsto)

    Does that solve the problem?


    Forrest Guo | MSDN Community Support | Feedback to manager

    Friday, April 5, 2013 7:43 AM
    Moderator
  • It's published to the full fileserver address, i.e.

    \\Au-melfil002\advisorydata\Advisory\Non-Client\ModellingAnalytics\4_Resources\Modelling Toolbar\

    I have attempted to install it from a mapped drive

    Both files have been resigned.  It was working for me, however after manually deleting some files in the debug folder it is no longer working.

    Monday, April 8, 2013 12:59 AM
  • I have two suggestions, either should work:

    1. Mapped network drive. If you want to do this, please map first, then publish to mapped network drive;
    2. Without mapping network drive. You publish the solution to UNC path, and install it from UNC path.

    This is because the network mapping transforms file path, which is referenced in deployment manifest(*.vsto) and application manifest(*.manifest). The path change need resign the manifest, and retrust the location.

    Does that make sense?


    Forrest Guo | MSDN Community Support | Feedback to manager

    Monday, April 8, 2013 2:55 AM
    Moderator
  • I have performed the following actions, however the same error still occurs:

    • I rebuilt the project and published it to the H:/4_Resources/Modelling Toolbar/
    • I rewrote the post deploy script (as a new project)
    • I included it as a reference
    • I updated the maniest
    • I resigned the manifest and the .vsto file with reference to H:
    • I installed the vsto from H:/4_Resources/Modelling Toolbar/

    I was not able to change the update path because it needs to be a UNC path, and obviously it should remain a UNC path so that users can install it from regardless of whether or not they have that path mapped.

    Tuesday, April 9, 2013 1:12 AM
  • There're two *.vsto files in publish folder. After you update .vsto(in same path as setup.exe), have you copied it over to folder (Application Files\SolutionName_1_0_0_0)?

    You can also check the solution that I use at: http://sdrv.ms/XAabxh

    It's basically following the MSDN walkthough.


    Forrest Guo | MSDN Community Support | Feedback to manager

    Tuesday, April 9, 2013 2:24 AM
    Moderator
  • Yep, I have copied the .vsto file to the subdirectory.

    I have discovered some unusual behaviour:

    • I tried referencing the old FileCopyPDA.dll with the original code (From when the installer was working)
    • I rebuilt, adjusted the manifest, resigned, etc. and it installed fine?
    • So I duplicated my current version of FileCopyPDA as a new project called PostDeploy
    • I updated the manifest so that it now reads:
    <?xml version="1.0" encoding="utf-8"?>
    <asmv1:assembly xsi:schemaLocation="urn:schemas-microsoft-com:asm.v1 assembly.adaptive.xsd" manifestVersion="1.0" xmlns:asmv1="urn:schemas-microsoft-com:asm.v1" xmlns="urn:schemas-microsoft-com:asm.v2" xmlns:asmv2="urn:schemas-microsoft-com:asm.v2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:co.v1="urn:schemas-microsoft-com:clickonce.v1" xmlns:asmv3="urn:schemas-microsoft-com:asm.v3" xmlns:dsig="http://www.w3.org/2000/09/xmldsig#" xmlns:co.v2="urn:schemas-microsoft-com:clickonce.v2">
      <asmv1:assemblyIdentity name="ModellingToolbar.dll" version="0.8.3.4" publicKeyToken="62c614bc780ff547" language="neutral" processorArchitecture="msil" type="win32" />
      <description xmlns="urn:schemas-microsoft-com:asm.v1">ModellingToolbar</description>
      <application />
      <entryPoint>
        <co.v1:customHostSpecified />
      </entryPoint>
      <trustInfo>
        <security>
          <applicationRequestMinimum>
            <PermissionSet Unrestricted="true" ID="Custom" SameSite="site" />
            <defaultAssemblyRequest permissionSetReference="Custom" />
          </applicationRequestMinimum>
          <requestedPrivileges xmlns="urn:schemas-microsoft-com:asm.v3">
            <!--
              UAC Manifest Options
              If you want to change the Windows User Account Control level replace the 
              requestedExecutionLevel node with one of the following.
    
            <requestedExecutionLevel  level="asInvoker" uiAccess="false" />
            <requestedExecutionLevel  level="requireAdministrator" uiAccess="false" />
            <requestedExecutionLevel  level="highestAvailable" uiAccess="false" />
    
             If you want to utilize File and Registry Virtualization for backward 
             compatibility then delete the requestedExecutionLevel node.
        -->
            <requestedExecutionLevel level="asInvoker" uiAccess="false" />
          </requestedPrivileges>
        </security>
      </trustInfo>
      <dependency>
        <dependentOS>
          <osVersionInfo>
            <os majorVersion="5" minorVersion="1" buildNumber="2600" servicePackMajor="0" />
          </osVersionInfo>
        </dependentOS>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.Windows.CommonLanguageRuntime" version="4.0.30319.0" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.Office.Tools" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.Office.Tools.Common" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.Office.Tools.Excel" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.VisualStudio.Tools.Applications.Runtime" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true">
          <assemblyIdentity name="Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="FileCopyPDA.dll" size="12288">
          <assemblyIdentity name="FileCopyPDA" version="1.0.0.0" language="neutral" processorArchitecture="msil" />
          <hash>
            <dsig:Transforms>
              <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
            </dsig:Transforms>
            <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
            <dsig:DigestValue>mqii4EuVRDRRTxTDVjyuDSHo/Ps=</dsig:DigestValue>
          </hash>
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="Microsoft.Office.Tools.Common.v4.0.Utilities.dll" size="32664">
          <assemblyIdentity name="Microsoft.Office.Tools.Common.v4.0.Utilities" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" />
          <hash>
            <dsig:Transforms>
              <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
            </dsig:Transforms>
            <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
            <dsig:DigestValue>CtnCtseaMyfROIGe0ENdGO6arHg=</dsig:DigestValue>
          </hash>
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="ModellingToolbar.dll" size="212480">
          <assemblyIdentity name="ModellingToolbar" version="1.0.0.0" language="neutral" processorArchitecture="msil" />
          <hash>
            <dsig:Transforms>
              <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
            </dsig:Transforms>
            <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
            <dsig:DigestValue>sUop4QpMYeDSCd+fwM96tyMlRkM=</dsig:DigestValue>
          </hash>
        </dependentAssembly>
      </dependency>
      <dependency>
        <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="PostDeploy.dll" size="18432">
          <assemblyIdentity name="PostDeploy" version="1.0.0.0" language="neutral" processorArchitecture="msil" />
          <hash>
            <dsig:Transforms>
              <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
            </dsig:Transforms>
            <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
            <dsig:DigestValue>feqMhaXQoVB1pgzAITChUjGsHmQ=</dsig:DigestValue>
          </hash>
        </dependentAssembly>
      </dependency>
      <file name="Data\Analytics VBA.xlam" size="483169">
        <hash>
          <dsig:Transforms>
            <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
          </dsig:Transforms>
          <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
          <dsig:DigestValue>uyz3vgCL4Et5AIyCaVJ4m86ovl4=</dsig:DigestValue>
        </hash>
      </file>
      <file name="Data\Table Library.xlsx" size="40619">
        <hash>
          <dsig:Transforms>
            <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
          </dsig:Transforms>
          <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
          <dsig:DigestValue>uuqAOxczZml8Izm/RXtPhBuMhO4=</dsig:DigestValue>
        </hash>
      </file>
      <file name="ModellingToolbar.dll.config" size="2035">
        <hash>
          <dsig:Transforms>
            <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" />
          </dsig:Transforms>
          <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" />
          <dsig:DigestValue>mLXELhKdDKTy6lHpMDKThMfGV8o=</dsig:DigestValue>
        </hash>
      </file>
      <vstav3:addIn xmlns:vstav3="urn:schemas-microsoft-com:vsta.v3">
        <vstav3:entryPointsCollection>
          <vstav3:entryPoints>
            <vstav3:entryPoint class="AnalyticsToolbar.ThisAddIn">
              <assemblyIdentity name="ModellingToolbar" version="1.0.0.0" language="neutral" processorArchitecture="msil" />
            </vstav3:entryPoint>
          </vstav3:entryPoints>
        </vstav3:entryPointsCollection>
        <vstav3:update enabled="true" />
        <vstav3:postActions>
          <vstav3:postAction>
            <vstav3:entryPoint class="PostDeploy.PostDeploy">
              <assemblyIdentity name="PostDeploy" version="1.0.0.0" language="neutral" processorArchitecture="msil" />
            </vstav3:entryPoint>
            <vstav3:postActionData>
            </vstav3:postActionData>
          </vstav3:postAction>
        </vstav3:postActions>
        <vstav3:application>
          <vstov4:customizations xmlns:vstov4="urn:schemas-microsoft-com:vsto.v4">
            <vstov4:customization>
              <vstov4:appAddIn application="Excel" loadBehavior="3" keyName="ModellingToolbar">
                <vstov4:friendlyName>AnalyticsToolbar</vstov4:friendlyName>
                <vstov4:description>ModellingToolbar</vstov4:description>
                <vstov4.1:ribbonTypes xmlns:vstov4.1="urn:schemas-microsoft-com:vsto.v4.1">
                  <vstov4.1:ribbonType name="AnalyticsToolbar.AnalyticsToolbar, ModellingToolbar, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
                </vstov4.1:ribbonTypes>
              </vstov4:appAddIn>
            </vstov4:customization>
          </vstov4:customizations>
        </vstav3:application>
      </vstav3:addIn>
    <publisherIdentity name="CN=PWCAU\Carl Gabel" issuerKeyHash="44fc7b7d4e21f7f9cc5d017925abeb59f4a78bc2" /><Signature Id="StrongNameSignature" xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1" /><Reference URI=""><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature" /><Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /><DigestValue>tpuq36wfQ1+/7gir0tEyXKEanzA=</DigestValue></Reference></SignedInfo><SignatureValue>ZHotBOGN4TAghXWV1HuUM5UX9hY7num97nVy4G51w8ytQL7aHgAdPiw8EABgJD6AbXrdxCaWBwKS5c663GrDa5nPYpvsL/ISq9SCv9LizZY1vZSiPPa4LUCnnHl9JQy2vG/WVPNGgwBt+EHmXvuqbjfTL9bGMFhlXE6nXEuVHeI=</SignatureValue><KeyInfo Id="StrongNameKeyInfo"><KeyValue><RSAKeyValue><Modulus>xIizsL+NiItZvTDRLA2vitpQk6l9QBY0VUPMgm0bX0tvxNeskK2oW4b5SjGLVKG8I0g7thcRSWAYpgnjt3KSCYjZ613LNRsyUr3mZtaWt2G0RyvfaJR7X9rlD16ucCcr3sl5VBg29nBAxzhCD3jDGV++1Lan7AAQsmKWE3Jpff0=</Modulus><Exponent>AQAB</Exponent></RSAKeyValue></KeyValue><msrel:RelData xmlns:msrel="http://schemas.microsoft.com/windows/rel/2005/reldata"><r:license xmlns:r="urn:mpeg:mpeg21:2003:01-REL-R-NS" xmlns:as="http://schemas.microsoft.com/windows/pki/2005/Authenticode"><r:grant><as:ManifestInformation Hash="309f1aa15c32d1d2ab08eebf5f431facdfaa9bb6" Description="" Url=""><as:assemblyIdentity name="ModellingToolbar.dll" version="0.8.3.4" publicKeyToken="62c614bc780ff547" language="neutral" processorArchitecture="msil" type="win32" /></as:ManifestInformation><as:SignedBy /><as:AuthenticodePublisher><as:X509SubjectName>CN=PWCAU\Carl Gabel</as:X509SubjectName></as:AuthenticodePublisher></r:grant><r:issuer><Signature Id="AuthenticodeSignature" xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1" /><Reference URI=""><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature" /><Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /><DigestValue>DtfYLNL9F06h4Vfz5N6TP86yVC4=</DigestValue></Reference></SignedInfo><SignatureValue>Oo2itAZIQ6o5tifcbhNXSshrmKdXyilbb207ZQZ5i52f50YpRXfPgeP8n1/zJwSj8RpBFwr2Y/nvRd3Xqk9KFfNHpmS+rkFpwZvvhg9A31JyrldSdXUyNGdmf64AUk8KdBZpXF+O6Pij5Kp8/RrIIys9T7Ld8PriUaKnKXb1OXY=</SignatureValue><KeyInfo><KeyValue><RSAKeyValue><Modulus>xIizsL+NiItZvTDRLA2vitpQk6l9QBY0VUPMgm0bX0tvxNeskK2oW4b5SjGLVKG8I0g7thcRSWAYpgnjt3KSCYjZ613LNRsyUr3mZtaWt2G0RyvfaJR7X9rlD16ucCcr3sl5VBg29nBAxzhCD3jDGV++1Lan7AAQsmKWE3Jpff0=</Modulus><Exponent>AQAB</Exponent></RSAKeyValue></KeyValue><X509Data><X509Certificate>MIIB2TCCAUKgAwIBAgIQF2tBiDEQk59Hb2/VpAmPszANBgkqhkiG9w0BAQUFADArMSkwJwYDVQQDHiAAUABXAEMAQQBVAFwAQwBhAHIAbAAgAEcAYQBiAGUAbDAeFw0xMzAyMTMyMzM4NTNaFw0xNDAyMTQwNTM4NTNaMCsxKTAnBgNVBAMeIABQAFcAQwBBAFUAXABDAGEAcgBsACAARwBhAGIAZQBsMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDEiLOwv42Ii1m9MNEsDa+K2lCTqX1AFjRVQ8yCbRtfS2/E16yQrahbhvlKMYtUobwjSDu2FxFJYBimCeO3cpIJiNnrXcs1GzJSveZm1pa3YbRHK99olHtf2uUPXq5wJyveyXlUGDb2cEDHOEIPeMMZX77UtqfsABCyYpYTcml9/QIDAQABMA0GCSqGSIb3DQEBBQUAA4GBADCjJbyqFb8aoolbfMrWqO7Gad8VG4Wz1hFgRvdSUXfOB4L6qQ5HO+XRgI3cqIeYWWrdJkHEUcFGXGAbhfFB8Tvrfsw7G1y5XHY6gqDEniT19WtIVuhlKFh3RAegE8cHUnUF1SQMJmaA1FVvPwDpb+3U6kphBw0Wv9MaNFnxxGDC</X509Certificate></X509Data></KeyInfo></Signature></r:issuer></r:license></msrel:RelData></KeyInfo></Signature></asmv1:assembly>
    • Note that I still have references to FileCopyPDA, but the PostActions refers to PostDeploy.
    • I rebuilt, adjusted the manifest, resigned, etc. and it installed...
    • --> However PostDeploy doesn't execute as a post deployment script, FileCopyPDA executes instead (PostDeploy creates folders with different names to FileCopyPDA, also post deploy has a bunch of MsgBoxes that should pop up).
    • I then removed the reference to FileCopyPDA
    • I rebuilt, adjusted the manifest, resigned, etc. and it installed --> The error cannot find the assembly PostDeploy occured.

    Somehow it's looking for the old .dll and running that instead of the new .dll despite having a completely different name?

    Tuesday, April 9, 2013 3:59 AM
  • I have compared the manifest above with manifest in my side, found that you have below reference, but I don't have.

    <assemblyIdentity name="Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0"

    You mentioned that the FileCopyPDA project reference has worked before, have you checked target framework between the working version and non-working version? Make sure the FileCopyPDA.dll.deploy is out there in publish folder and it's dll version is v1.0.0.0

    Does that hit the issue?


    Forrest Guo | MSDN Community Support | Feedback to manager

    Tuesday, April 9, 2013 7:03 AM
    Moderator
  • Hello Riva, any progress?

    Forrest Guo | MSDN Community Support | Feedback to manager

    Monday, April 15, 2013 3:45 AM
    Moderator
  • the postAction project,  you need  import  "Microsoft.VisualStudio.Tools.Applications.Runtime"  with .net 4.0 framework enviroment.  

    "Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0"   can be used with .net 3.5 enviroment


    Friday, June 16, 2017 4:05 AM