{"id":24,"date":"2007-11-10T14:18:18","date_gmt":"2007-11-10T12:18:18","guid":{"rendered":"http:\/\/tom.paschenda.org\/blog\/?page_id=24"},"modified":"2017-12-31T14:57:35","modified_gmt":"2017-12-31T12:57:35","slug":"vba-library","status":"publish","type":"page","link":"https:\/\/tom.paschenda.org\/blog\/?page_id=24","title":{"rendered":"VBA Library"},"content":{"rendered":"<p>I have put together a little collection of utility functions for Excel VBA.<\/p>\n<p>You may <strong>download <\/strong>it here:<br \/>\n<a href=\"http:\/\/tom.paschenda.org\/vbalibrary.zip\" title=\"VBA Library\">http:\/\/tom.paschenda.org\/vbalibrary.zip<\/a><\/p>\n<p>Feel free to use the functions in your project (be it commercially or not) or copy and modify them as you desire.<\/p>\n<p>Currently there are three  modules:<\/p>\n<ul>\n<li><a href=\"http:\/\/tom.paschenda.org\/vbalibrary\/docs\/files\/libArrays-bas.html\" title=\"Documentation for libArrays\">libArrays<\/a> contains functions to work with arrays (currently contains only one function to check vba arrays for equality)<\/li>\n<li><a href=\"http:\/\/tom.paschenda.org\/vbalibrary\/docs\/files\/libOffice-bas.html\" title=\"Documentation for libOffice\">libOffice<\/a> contains functions to talk to MS Word and MS Outlook from within Excel<\/li>\n<li><a href=\"http:\/\/tom.paschenda.org\/vbalibrary\/docs\/files\/libRanges-bas.html\" title=\"Documentation for libRanges\">libRanges<\/a> contains some basic range navigation and editing commands<\/li>\n<li><a href=\"http:\/\/tom.paschenda.org\/vbalibrary\/docs\/files\/libStrings-bas.html\" title=\"Documentation for libStrings\">libStrings<\/a> provides a few string processing functions<\/li>\n<li><a href=\"http:\/\/tom.paschenda.org\/vbalibrary\/docs\/files\/libVB-bas.html\" title=\"Documentation for libVB\">libVB<\/a> contains functions to deal with VBA code within excel projects<\/li>\n<\/ul>\n<p>Here is a <a href=\"http:\/\/tom.paschenda.org\/vbalibrary\/docs\/index\/Functions.html\" title=\"List of Functions\">list of all functions<\/a>.<\/p>\n<p>The documentation has been generated using <a href=\"http:\/\/www.naturaldocs.org\/\" title=\"NaturalDocs\">NaturalDocs<\/a>, a free <a href=\"http:\/\/www.stack.nl\/~dimitri\/doxygen\/\" title=\"Doxygen\">Doxygen<\/a>-like documentation system that understands Visual Basic.<\/p>\n<p>If you have any questions or comments, please drop me a <a href=\"http:\/\/tom.paschenda.org\/blog\/?page_id=11\" title=\"Impressum\">mail<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have put together a little collection of utility functions for Excel VBA. You may download it here: http:\/\/tom.paschenda.org\/vbalibrary.zip Feel free to use the functions in your project (be it commercially or not) or copy and modify them as you desire. Currently there are three modules: libArrays contains functions to work with arrays (currently contains [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":82,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-24","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tom.paschenda.org\/blog\/index.php?rest_route=\/wp\/v2\/pages\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tom.paschenda.org\/blog\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tom.paschenda.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tom.paschenda.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tom.paschenda.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=24"}],"version-history":[{"count":1,"href":"https:\/\/tom.paschenda.org\/blog\/index.php?rest_route=\/wp\/v2\/pages\/24\/revisions"}],"predecessor-version":[{"id":86,"href":"https:\/\/tom.paschenda.org\/blog\/index.php?rest_route=\/wp\/v2\/pages\/24\/revisions\/86"}],"up":[{"embeddable":true,"href":"https:\/\/tom.paschenda.org\/blog\/index.php?rest_route=\/wp\/v2\/pages\/82"}],"wp:attachment":[{"href":"https:\/\/tom.paschenda.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}