{"id":1681,"date":"2017-01-23T00:03:15","date_gmt":"2017-01-23T00:03:15","guid":{"rendered":"http:\/\/elbsolutions.com\/projects\/?p=1681"},"modified":"2022-02-03T11:24:31","modified_gmt":"2022-02-03T17:24:31","slug":"get-com-enabled-vba-compatible-vsto-project-work-using-installer","status":"publish","type":"post","link":"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/","title":{"rendered":"Get COM enabled VBA compatible VSTO project to work using an installer"},"content":{"rendered":"<p>First, here is what we are looking for our of our VSTO<\/p>\n<ul>\n<li>VSTO just works<\/li>\n<li>VBA code can use the new libraries AND have intellisense (eg pre-binding)<\/li>\n<li>to be used by all users of the computer (click once installer is thus &#8216;out&#8217; thus &#8211; custom installer)<\/li>\n<\/ul>\n<p><strong>UPDATE: <a href=\"http:\/\/elbsolutions.com\/projects\/register-tlb-file-vba-use-destination-machine-vsto-running-success\/\">This article has the answer<\/a>: The stuff below is also good information to use and do.<\/strong><!--more--><\/p>\n<p>All went well until the other developer started &#8220;handing over&#8221; code to me after he renamed the modules so they would group together (prefixed w. the same 3 letters). Sometimes things would just work and the VSTO stuff written in c# would just work from VBA and then for days on end &#8211; nothing. What was going on is that a build from Visual Studio as a designer did all the proper registry additions and the installers missed a few.<!--more--><\/p>\n<p>Using RegShot &#8211; we narrowed it down to a few items that were missing. The project had some deficiencies though.<\/p>\n<ol>\n<li>paths on my new VM which we used to back track things were not relative. <a href=\"http:\/\/stackoverflow.com\/questions\/6912608\/installshield-relative-file-paths\">Use this article\u00a0to replace the solution directory<\/a> with a variable\u00a0&lt;VSSolutionFoler&gt; or since it is in an xml file &#8211; &amp;lt;VSSolutionFoler&amp;gt; (which is what you would copy in to your .isl file. So if your project is c:\\users\\bob\\Desktop\\mysoldir\\myproj\\myproj.sln then replace the parent directory with\u00a0<span>&amp;lt;<\/span><span>VSSolutionFoler&amp;gt; for files you want copied. THEN open your project and check the Files section of your InstallShield wizard setup to ensure it worked. Rebuilld and you should have no errors in your output log.<\/span><\/li>\n<li>Certain items in order to build the custom InstallShield installer needed to be downloaded \u00a0&#8211; <a href=\"http:\/\/stackoverflow.com\/questions\/12875615\/installshield-le-spring-2012-cant-find-setup-prerequisites\">solution here<\/a><\/li>\n<li>GUID&#8217;s for registry items kept changing &#8211; <a href=\"https:\/\/www.guidgenerator.com\/online-guid-generator.aspx\">how to calm that down to be constant guids<\/a><\/li>\n<\/ol>\n<p>Other Links:<\/p>\n<ul>\n<li>http:\/\/stackoverflow.com\/questions\/148879\/why-does-my-net-application-crash-when-run-from-a-network-drive (<a href=\"http:\/\/stackoverflow.com\/questions\/148879\/why-does-my-net-application-crash-when-run-from-a-network-drive\">link<\/a>)<\/li>\n<li>https:\/\/msdn.microsoft.com\/en-us\/library\/t71a733d(v=vs.140).aspx (<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/t71a733d(v=vs.140).aspx\">link<\/a>)<\/li>\n<li>http:\/\/stackoverflow.com\/questions\/33230794\/deploying-vsto-add-in-to-all-users (<a href=\"http:\/\/stackoverflow.com\/questions\/33230794\/deploying-vsto-add-in-to-all-users\">link<\/a>)<\/li>\n<li>http:\/\/sharepoint.stackexchange.com\/questions\/105992\/which-special-characters-are-not-allowed-in-sharepoint-2013-files-folders (<a href=\"http:\/\/sharepoint.stackexchange.com\/questions\/105992\/which-special-characters-are-not-allowed-in-sharepoint-2013-files-folders\">link<\/a>)<\/li>\n<li>https:\/\/msdn.microsoft.com\/en-us\/library\/cc442767.aspx#Obtain (<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/cc442767.aspx#Obtain\">link<\/a>)<\/li>\n<li>https:\/\/msdn.microsoft.com\/en-us\/library\/bb608621.aspx (<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bb608621.aspx\">link<\/a>)<\/li>\n<li>https:\/\/msdn.microsoft.com\/en-us\/library\/microsoft.office.tools.addinbase.requestcomaddinautomationservice.aspx (<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/microsoft.office.tools.addinbase.requestcomaddinautomationservice.aspx\">link<\/a>)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>First, here is what we are looking for our of our VSTO VSTO just works VBA code can use the new libraries AND have intellisense (eg pre-binding) to be used by all users of the computer (click once installer is thus &#8216;out&#8217; thus &#8211; custom installer) UPDATE: This article has the answer: The stuff below [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1681","post","type-post","status-publish","format-standard","hentry","category-general"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Get COM enabled VBA compatible VSTO project to work using an installer - ELB Solutions.com Inc.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get COM enabled VBA compatible VSTO project to work using an installer - ELB Solutions.com Inc.\" \/>\n<meta property=\"og:description\" content=\"First, here is what we are looking for our of our VSTO VSTO just works VBA code can use the new libraries AND have intellisense (eg pre-binding) to be used by all users of the computer (click once installer is thus &#8216;out&#8217; thus &#8211; custom installer) UPDATE: This article has the answer: The stuff below [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/\" \/>\n<meta property=\"og:site_name\" content=\"ELB Solutions.com Inc.\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-23T00:03:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-03T17:24:31+00:00\" \/>\n<meta name=\"author\" content=\"Etienne Bley\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Etienne Bley\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\\\/\"},\"author\":{\"name\":\"Etienne Bley\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"headline\":\"Get COM enabled VBA compatible VSTO project to work using an installer\",\"datePublished\":\"2017-01-23T00:03:15+00:00\",\"dateModified\":\"2022-02-03T17:24:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\\\/\"},\"wordCount\":387,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\\\/\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\\\/\",\"name\":\"Get COM enabled VBA compatible VSTO project to work using an installer - ELB Solutions.com Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\"},\"datePublished\":\"2017-01-23T00:03:15+00:00\",\"dateModified\":\"2022-02-03T17:24:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get COM enabled VBA compatible VSTO project to work using an installer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\",\"name\":\"ELB Solutions.com Inc.\",\"description\":\"Bringing all your IT Pieces together\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\",\"name\":\"Etienne Bley\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"caption\":\"Etienne Bley\"},\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/author\\\/etienne-bley\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Get COM enabled VBA compatible VSTO project to work using an installer - ELB Solutions.com Inc.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/","og_locale":"en_US","og_type":"article","og_title":"Get COM enabled VBA compatible VSTO project to work using an installer - ELB Solutions.com Inc.","og_description":"First, here is what we are looking for our of our VSTO VSTO just works VBA code can use the new libraries AND have intellisense (eg pre-binding) to be used by all users of the computer (click once installer is thus &#8216;out&#8217; thus &#8211; custom installer) UPDATE: This article has the answer: The stuff below [&hellip;]","og_url":"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/","og_site_name":"ELB Solutions.com Inc.","article_published_time":"2017-01-23T00:03:15+00:00","article_modified_time":"2022-02-03T17:24:31+00:00","author":"Etienne Bley","twitter_misc":{"Written by":"Etienne Bley","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/#article","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/"},"author":{"name":"Etienne Bley","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"headline":"Get COM enabled VBA compatible VSTO project to work using an installer","datePublished":"2017-01-23T00:03:15+00:00","dateModified":"2022-02-03T17:24:31+00:00","mainEntityOfPage":{"@id":"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/"},"wordCount":387,"articleSection":["General"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/","url":"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/","name":"Get COM enabled VBA compatible VSTO project to work using an installer - ELB Solutions.com Inc.","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/#website"},"datePublished":"2017-01-23T00:03:15+00:00","dateModified":"2022-02-03T17:24:31+00:00","author":{"@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"breadcrumb":{"@id":"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/elbsolutions.com\/projects\/get-com-enabled-vba-compatible-vsto-project-work-using-installer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/elbsolutions.com\/projects\/"},{"@type":"ListItem","position":2,"name":"Get COM enabled VBA compatible VSTO project to work using an installer"}]},{"@type":"WebSite","@id":"https:\/\/elbsolutions.com\/projects\/#website","url":"https:\/\/elbsolutions.com\/projects\/","name":"ELB Solutions.com Inc.","description":"Bringing all your IT Pieces together","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/elbsolutions.com\/projects\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39","name":"Etienne Bley","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","caption":"Etienne Bley"},"url":"https:\/\/elbsolutions.com\/projects\/author\/etienne-bley\/"}]}},"_links":{"self":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/comments?post=1681"}],"version-history":[{"count":6,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1681\/revisions"}],"predecessor-version":[{"id":1701,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1681\/revisions\/1701"}],"wp:attachment":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/media?parent=1681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/categories?post=1681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/tags?post=1681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}