{"id":917,"date":"2014-10-22T22:15:26","date_gmt":"2014-10-22T22:15:26","guid":{"rendered":"http:\/\/elbsolutions.com\/projects\/?p=917"},"modified":"2022-02-03T11:25:00","modified_gmt":"2022-02-03T17:25:00","slug":"vba-export-vba-modules-archiving","status":"publish","type":"post","link":"https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/","title":{"rendered":"VBA to &#8230; export VBA modules for archiving or other"},"content":{"rendered":"<p>Neat.\u00a0<a href=\"http:\/\/www.cpearson.com\/Excel\/VBE.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/www.cpearson.com\/Excel\/VBE.aspx<\/a>\u00a0 Now I can export the modules for text version control \u00a0(so we can see the changes). AND use it to standardize all the code between little small projects to ensure that all the good ideas from one period in time can be compared to other projects done in an earlier time.<\/p>\n<p>For instance, lets say we made a great &#8220;look for header&#8221; routine 4 months ago. Today, the header row is not fixed to row 1 any longer. If we make a new routine that is a little more generic &#8211; it needs to have a different name but if we backdate all the other routines, then the idea is better for all projects. The tools in the above link give us all we need to get this completed. &#8230; and the code above works &#8211; with few changes.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Neat.\u00a0http:\/\/www.cpearson.com\/Excel\/VBE.aspx\u00a0 Now I can export the modules for text version control \u00a0(so we can see the changes). AND use it to standardize all the code between little small projects to ensure that all the good ideas from one period in time can be compared to other projects done in an earlier time. For instance, lets [&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-917","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>VBA to ... export VBA modules for archiving or other - 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\/vba-export-vba-modules-archiving\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA to ... export VBA modules for archiving or other - ELB Solutions.com Inc.\" \/>\n<meta property=\"og:description\" content=\"Neat.\u00a0http:\/\/www.cpearson.com\/Excel\/VBE.aspx\u00a0 Now I can export the modules for text version control \u00a0(so we can see the changes). AND use it to standardize all the code between little small projects to ensure that all the good ideas from one period in time can be compared to other projects done in an earlier time. For instance, lets [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/\" \/>\n<meta property=\"og:site_name\" content=\"ELB Solutions.com Inc.\" \/>\n<meta property=\"article:published_time\" content=\"2014-10-22T22:15:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-03T17:25:00+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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/vba-export-vba-modules-archiving\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/vba-export-vba-modules-archiving\\\/\"},\"author\":{\"name\":\"Etienne Bley\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"headline\":\"VBA to &#8230; export VBA modules for archiving or other\",\"datePublished\":\"2014-10-22T22:15:26+00:00\",\"dateModified\":\"2022-02-03T17:25:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/vba-export-vba-modules-archiving\\\/\"},\"wordCount\":153,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/vba-export-vba-modules-archiving\\\/\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/vba-export-vba-modules-archiving\\\/\",\"name\":\"VBA to ... export VBA modules for archiving or other - ELB Solutions.com Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\"},\"datePublished\":\"2014-10-22T22:15:26+00:00\",\"dateModified\":\"2022-02-03T17:25:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/vba-export-vba-modules-archiving\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/vba-export-vba-modules-archiving\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/vba-export-vba-modules-archiving\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VBA to &#8230; export VBA modules for archiving or other\"}]},{\"@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":"VBA to ... export VBA modules for archiving or other - 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\/vba-export-vba-modules-archiving\/","og_locale":"en_US","og_type":"article","og_title":"VBA to ... export VBA modules for archiving or other - ELB Solutions.com Inc.","og_description":"Neat.\u00a0http:\/\/www.cpearson.com\/Excel\/VBE.aspx\u00a0 Now I can export the modules for text version control \u00a0(so we can see the changes). AND use it to standardize all the code between little small projects to ensure that all the good ideas from one period in time can be compared to other projects done in an earlier time. For instance, lets [&hellip;]","og_url":"https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/","og_site_name":"ELB Solutions.com Inc.","article_published_time":"2014-10-22T22:15:26+00:00","article_modified_time":"2022-02-03T17:25:00+00:00","author":"Etienne Bley","twitter_misc":{"Written by":"Etienne Bley","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/#article","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/"},"author":{"name":"Etienne Bley","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"headline":"VBA to &#8230; export VBA modules for archiving or other","datePublished":"2014-10-22T22:15:26+00:00","dateModified":"2022-02-03T17:25:00+00:00","mainEntityOfPage":{"@id":"https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/"},"wordCount":153,"articleSection":["General"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/","url":"https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/","name":"VBA to ... export VBA modules for archiving or other - ELB Solutions.com Inc.","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/#website"},"datePublished":"2014-10-22T22:15:26+00:00","dateModified":"2022-02-03T17:25:00+00:00","author":{"@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"breadcrumb":{"@id":"https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/elbsolutions.com\/projects\/vba-export-vba-modules-archiving\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/elbsolutions.com\/projects\/"},{"@type":"ListItem","position":2,"name":"VBA to &#8230; export VBA modules for archiving or other"}]},{"@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\/917","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=917"}],"version-history":[{"count":4,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/917\/revisions"}],"predecessor-version":[{"id":2778,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/917\/revisions\/2778"}],"wp:attachment":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/media?parent=917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/categories?post=917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/tags?post=917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}