{"id":7080,"date":"2022-02-27T12:00:30","date_gmt":"2022-02-27T12:00:30","guid":{"rendered":"https:\/\/www.samlogic.net\/blog\/?p=7080"},"modified":"2022-03-21T09:47:24","modified_gmt":"2022-03-21T09:47:24","slug":"how-to-test-if-microsoft-access-or-microsoft-excel-is-installed","status":"publish","type":"post","link":"https:\/\/www.samlogic.net\/blog\/2022\/02\/how-to-test-if-microsoft-access-or-microsoft-excel-is-installed\/","title":{"rendered":"How to test if Microsoft Access or Microsoft Excel is installed"},"content":{"rendered":"<p><img decoding=\"async\" loading=\"lazy\" class=\"alignright\" src=\"https:\/\/www.samlogic.net\/visual-installer\/news\/visual-installer-2022\/pictures\/access-excel-logotypes-black-white.png\" width=\"250\" height=\"117\" border=\"0\" alt=\"Logotypes - Access and Excel\">In <a href=\"https:\/\/www.samlogic.net\/blog\/2020\/07\/how-to-check-if-microsoft-office-is-installed-during-installation\/\">this blog post<\/a> we described how to check if Microsoft Office is installed in a computer during an installation. But what if Microsoft Word and Microsoft PowerPoint is installed, but not Microsoft Access, which is what you want? How to handle this situation in Visual Installer?<\/p>\n<p>In the new <a href=\"https:\/\/www.samlogic.net\/visual-installer\/visual-installer.htm\" target=\"_blank\" rel=\"noopener\">Visual Installer 2022<\/a> the answer is to use a new script condition that we have added to the script language. The name of the new script condition is <strong>IF ACCESS_INSTALLED<\/strong> and with this script condition you can check if <strong>Microsoft Access<\/strong> <em>specifically<\/em> has been installed in the computer. So instead of trying to use the Microsoft Office condition check (as described in the earlier <a href=\"https:\/\/www.samlogic.net\/blog\/2020\/07\/how-to-check-if-microsoft-office-is-installed-during-installation\/\">blog post<\/a>) you can use the new Microsoft Access condition check instead.<\/p>\n<p>Below we show two examples of how to use the new condition:<\/p>\n<div style=\"background-color: #f4f4f4; padding: 8px;\"><span style=\"color: #008000;\">\/\/ Example 1 &#8211; Tests if Microsoft Access is installed in the system<\/span><br \/>\n<span style=\"color: #000080;\">IF<\/span> ACCESS_INSTALLED<br \/>\n<span style=\"color: #000080;\">\u00a0 RUN<\/span> <span style=\"color: #800000;\">%DESTDIR<\/span>\\InstallAccessTools.exe<br \/>\n<span style=\"color: #000080;\">END IF<\/span><br \/>\n<span style=\"color: #000080;\"> &nbsp; <\/span><br \/>\n<span style=\"color: #008000;\">\/\/ Example 2 &#8211; Tests if Microsoft Access is not installed in the system<\/span><br \/>\n<span style=\"color: #000080;\">IF NOT<\/span> ACCESS_INSTALLED<br \/>\n<span style=\"color: #000080;\">\u00a0 MSGBOX<\/span> &#8220;Information&#8221;, &#8220;Microsoft Access is not installed in this computer!&#8221;, 2<br \/>\n<span style=\"color: #000080;\">END IF<\/span>\n<\/div>\n<p><span style=\"color: #000080;\"> &nbsp; <\/span><br \/>\nYou can also test if <strong>Microsoft Excel<\/strong> has been installed or not in the same way. Below we show two examples of how to use the Excel condition:<\/p>\n<div style=\"background-color: #f4f4f4; padding: 8px;\"><span style=\"color: #008000;\">\/\/ Example 1 &#8211; Tests if Microsoft Excel is installed in the system<\/span><br \/>\n<span style=\"color: #000080;\">IF<\/span> EXCEL_INSTALLED<br \/>\n<span style=\"color: #000080;\">\u00a0 RUN<\/span> <span style=\"color: #800000;\">%DESTDIR<\/span>\\InstallExcelTools.exe<br \/>\n<span style=\"color: #000080;\">END IF<\/span><br \/>\n<span style=\"color: #000080;\"> &nbsp; <\/span><br \/>\n<span style=\"color: #008000;\">\/\/ Example 2 &#8211; Tests if Microsoft Excel is not installed in the system<\/span><br \/>\n<span style=\"color: #000080;\">IF NOT<\/span> EXCEL_INSTALLED<br \/>\n<span style=\"color: #000080;\">\u00a0 MSGBOX<\/span> &#8220;Information&#8221;, &#8220;Microsoft Excel is not installed in this computer!&#8221;, 2<br \/>\n<span style=\"color: #000080;\">END IF<\/span>\n<\/div>\n<p><span style=\"color: #000080;\"> &nbsp; <\/span><br \/>\nIt is also useful to know if the user has installed a <strong>32 bit<\/strong> or <strong>64 bit<\/strong> version of the Office program. But here you can use the same condition in Visual Installer&#8217;s script language as before (see the second half of <a href=\"https:\/\/www.samlogic.net\/blog\/2020\/07\/how-to-check-if-microsoft-office-is-installed-during-installation\/\">this blog post<\/a> for details).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog post we described how to check if Microsoft Office is installed in a computer during an installation. But what if Microsoft Word and Microsoft PowerPoint is installed, but not Microsoft Access, which is what you want? How to handle this situation in Visual Installer? In the new Visual Installer 2022 the answer &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.samlogic.net\/blog\/2022\/02\/how-to-test-if-microsoft-access-or-microsoft-excel-is-installed\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;How to test if Microsoft Access or Microsoft Excel is installed&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[10,15],"tags":[],"_links":{"self":[{"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/posts\/7080"}],"collection":[{"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/comments?post=7080"}],"version-history":[{"count":54,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/posts\/7080\/revisions"}],"predecessor-version":[{"id":7264,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/posts\/7080\/revisions\/7264"}],"wp:attachment":[{"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/media?parent=7080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/categories?post=7080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.samlogic.net\/blog\/wp-json\/wp\/v2\/tags?post=7080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}