{"id":2316,"date":"2013-01-09T10:04:01","date_gmt":"2013-01-09T10:04:01","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=2316"},"modified":"2025-06-27T05:51:48","modified_gmt":"2025-06-27T05:51:48","slug":"vba-macro-errors-related-to-exd-files","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/","title":{"rendered":"VBA Macro Errors related to EXD Files"},"content":{"rendered":"<p>While deploying your VBA Macro on client\u2019s environment or all of sudden during development you may experience either of the following errors with your VBA macro.<\/p>\n<p style=\"padding-left: 30px\"><strong>*<\/strong>&nbsp;Can\u2019t find project or library<br \/>\n<strong>*<\/strong>&nbsp;Variable not defined<br \/>\n<strong>*<\/strong>&nbsp;Object library invalid<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1_VBAEXD.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter  wp-image-2317\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1_VBAEXD.jpg\" alt=\"\" width=\"736\" height=\"466\"><\/a><\/p>\n<p style=\"text-align: left\"><strong>Possible cause for error:&nbsp;<\/strong>As a developer; try to verify if you have recently updated your system. Sometimes, windows update installs the newer version of certain Visual Basic 6.0 Runtime files. These updates install the files appropriately; however it creates discrepancies with EXD files.<\/p>\n<p style=\"text-align: left;padding-left: 30px\">When you use Active X controls provided by runtime files; EXD files are created.&nbsp; After applying the updates; these EXD files becomes invalid with the newly updated runtime files resulting one of above mentioned errors.<\/p>\n<p style=\"text-align: left\"><strong>Solution:&nbsp;<\/strong>To fix errors; the older EXD files should be deleted from the system. This is safe because after compiling the macro, system will automatically generate these files based on the newer&nbsp;run time&nbsp;files.<\/p>\n<p style=\"text-align: left\"><strong>Steps for deleting EXD files:<\/strong><\/p>\n<p style=\"text-align: left;padding-left: 30px\"><strong>1.<\/strong>&nbsp;Run the command prompt&nbsp;(For Windows7\/Vista Run the command prompt as Administrator).<br \/>\n<strong>2.<\/strong>&nbsp;Enter the command to delete EXD files from machine&nbsp;<strong>\u201cDel C:\\*.EXD \/s\u201d<\/strong><\/p>\n<p style=\"text-align: left;padding-left: 60px\"><strong>Detail information on above mentioned command:<\/strong>&nbsp;\/S&nbsp;includes files in the specified directory shown at the prompt and all subdirectories,&nbsp;*.EXD&nbsp;includes all files with the EXD extension.<\/p>\n<p style=\"text-align: left;padding-left: 30px\"><strong>3.<\/strong>&nbsp;Exit the command prompt.<br \/>\n<strong>4.<\/strong>&nbsp;Finally compile the macro and see if it runs fine.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While deploying your VBA Macro on client\u2019s environment or all of sudden during development you may experience either of the following errors with your VBA macro. *&nbsp;Can\u2019t find project or library *&nbsp;Variable not defined *&nbsp;Object library invalid Possible cause for error:&nbsp;As a developer; try to verify if you have recently updated your system. Sometimes, windows\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[921,1512,2978],"class_list":["post-2316","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-exd","tag-macro-error","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA Macro Errors related to EXD Files<\/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:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA Macro Errors related to EXD Files\" \/>\n<meta property=\"og:description\" content=\"While deploying your VBA Macro on client\u2019s environment or all of sudden during development you may experience either of the following errors with your VBA macro. *&nbsp;Can\u2019t find project or library *&nbsp;Variable not defined *&nbsp;Object library invalid Possible cause for error:&nbsp;As a developer; try to verify if you have recently updated your system. Sometimes, windows\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-01-09T10:04:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-27T05:51:48+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1_VBAEXD.jpg\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/\",\"name\":\"VBA Macro Errors related to EXD Files\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1_VBAEXD.jpg\",\"datePublished\":\"2013-01-09T10:04:01+00:00\",\"dateModified\":\"2025-06-27T05:51:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1_VBAEXD.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1_VBAEXD.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VBA Macro Errors related to EXD Files\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA Macro Errors related to EXD Files","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:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/","og_locale":"en_US","og_type":"article","og_title":"VBA Macro Errors related to EXD Files","og_description":"While deploying your VBA Macro on client\u2019s environment or all of sudden during development you may experience either of the following errors with your VBA macro. *&nbsp;Can\u2019t find project or library *&nbsp;Variable not defined *&nbsp;Object library invalid Possible cause for error:&nbsp;As a developer; try to verify if you have recently updated your system. Sometimes, windows\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-01-09T10:04:01+00:00","article_modified_time":"2025-06-27T05:51:48+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1_VBAEXD.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/","name":"VBA Macro Errors related to EXD Files","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1_VBAEXD.jpg","datePublished":"2013-01-09T10:04:01+00:00","dateModified":"2025-06-27T05:51:48+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1_VBAEXD.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1_VBAEXD.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/09\/vba-macro-errors-related-to-exd-files\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"VBA Macro Errors related to EXD Files"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=2316"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2316\/revisions"}],"predecessor-version":[{"id":27423,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2316\/revisions\/27423"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=2316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=2316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=2316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}