{"id":1546,"date":"2023-11-17T10:49:24","date_gmt":"2023-11-17T10:49:24","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/"},"modified":"2023-12-06T05:50:24","modified_gmt":"2023-12-06T05:50:24","slug":"werkmappen-combineren","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/","title":{"rendered":"Hoe meerdere excel-werkmappen combineren met vba?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3181212156\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Om meerdere Excel-werkmappen te combineren, moet u een code gebruiken waarmee u kunt kiezen welke bestanden u wilt combineren, of u kunt naar een bepaalde padlocatie verwijzen en alle Excel-bestanden in de huidige werkmap combineren.<\/p><h2 class=\"wp-block-heading\"> VBA combineert meerdere werkmappen<\/h2><p> U kunt de volgende code gebruiken die de locatie gebruikt die ik heb genoemd in de padvariabele (een map op mijn systeembureaublad).<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim Path As String Dim Filename As String Dim Sheet As Worksheet Path = \"C:UsersDellDesktopsample-data\" Filename = Dir(Path &amp; \"*.xlsx\") Do While Filename &lt;&gt; \"\" Workbooks.Open Filename:=Path &amp; Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets Sheet.Copy After:=ThisWorkbook.Sheets(1) Next Sheet Workbooks(Filename).Close Filename = Dir() Loop<\/code><\/pre><h2 class=\"wp-block-heading\"> Stappen om Excel-bestanden te combineren met VBA<\/h2><ol><li> Open de Visual Basic Editor (zorg ervoor dat u het tabblad Ontwikkelaars inschakelt als u dit al op het lint hebt staan). <br><img loading=\"lazy\" decoding=\"async\" title=\"1-open-visuele-basis-editor\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png\" sizes=\"auto, \" srcset=\"\" alt=\"open the visual basic editor\" width=\"591\" height=\"138\"><\/li><li> Zoek daarna de huidige werkmap vanuit het projectvenster (control + r) en plaats er een nieuwe module in. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-zoek-de-huidige-werkmap\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-localiser-le-classeur-en-cours.png\" sizes=\"auto, \" srcset=\"\" alt=\"locate the current workbook\" width=\"454\" height=\"379\"><\/li><li> U krijgt een codevenster in de module (dubbelklik erop) waar u de code die u heeft moet plakken (zoals deze is). <br><img loading=\"lazy\" decoding=\"async\" title=\"3-codevenster in module\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-fenetre-de-code-dans-le-module.png\" sizes=\"auto, \" srcset=\"\" alt=\"code window in the module\" width=\"634\" height=\"227\"><\/li><li> Vanaf hier moet u de waarde van de padvariabele wijzigen met de maplocatie waar alle Excel-bestanden die u wilt combineren zich bevinden. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-veranderingswaarde-van-pad-variabele\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-modifier-la-valeur-de-la-variable-de-chemin.png\" sizes=\"auto, \" srcset=\"\" alt=\"change the value for the path variable\" width=\"479\" height=\"369\"><\/li><li> Voer aan het einde de code uit en u krijgt alle werkbladen in de werkmap in het huidige bestand.<\/li><\/ol><p class=\"content-box-grey\"> <em>Handige links: <a href=\"https:\/\/exceladvisor.org\/nl\/voer-een-macro-uit-2\/\">Een macro uitvoeren<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/nl\/een-macro-opnemen\/\">Macrorecorder<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/nl\/eenvoudige-visuele-editor\/\">Visual Basic Editor<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/nl\/persoonlijk-macronotitieboekje\/\">Handboek voor persoonlijke macro&#8217;s<\/a><\/em><\/p><p> Deze code opent elk bestand \u00e9\u00e9n voor \u00e9\u00e9n en kopieert elk werkblad \u00e9\u00e9n voor \u00e9\u00e9n en plakt het in het huidige bestand met dezelfde naam. Hier is dezelfde code, maar waarbij het scherm in het begin wordt bijgewerkt naar false om alles aan de backend uit te voeren.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim Path As String Dim Filename As String Dim Sheet As Worksheet Application.ScreenUpdating = False Path = \"C:UsersDellDesktopsample-data\" Filename = Dir(Path &amp; \"*.xlsx\") Do While Filename &lt;&gt; \"\" Workbooks.Open Filename:=Path &amp; Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets Sheet.Copy After:=ThisWorkbook.Sheets(1) Next Sheet Workbooks(Filename).Close Filename = Dir() Loop Application.ScreenUpdating = True End Sub<\/code><\/pre><p class=\"qt-tip\"> <strong>Opmerking:<\/strong> als u wilt leren hoe u gegevens uit meerdere werkmappen in \u00e9\u00e9n tabel kunt combineren, lees dan zeker deze handleiding.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/vba\/\">Wat is VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Gerelateerde tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/excel-bestand-kopieren\/\">Kopieer een Excel-bestand (werkmap) met VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/werkmap-activeren\/\">VBA Werkmap activeren (Excel-bestand)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/sluit-de-werkmap\/\">VBA Werkmap sluiten (Excel-bestand)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/maak-een-werkmap\/\">VBA Maak een nieuwe werkmap (Excel-bestand)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/verwijder-bestand\/\">VBA Werkmap verwijderen (Excel-bestand)<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1546","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Hoe meerdere Excel-werkmappen combineren via VBA?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie wordt uitgelegd hoe u VBA kunt gebruiken om meerdere Excel-bestanden in \u00e9\u00e9n te combineren.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe meerdere Excel-werkmappen combineren via VBA?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie wordt uitgelegd hoe u VBA kunt gebruiken om meerdere Excel-bestanden in \u00e9\u00e9n te combineren.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/\",\"name\":\"\u25b7 Hoe meerdere Excel-werkmappen combineren via VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png\",\"datePublished\":\"2023-11-17T10:49:24+00:00\",\"dateModified\":\"2023-12-06T05:50:24+00:00\",\"description\":\"In deze zelfstudie wordt uitgelegd hoe u VBA kunt gebruiken om meerdere Excel-bestanden in \u00e9\u00e9n te combineren.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe meerdere excel-werkmappen combineren met vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Hoe meerdere Excel-werkmappen combineren via VBA?","description":"In deze zelfstudie wordt uitgelegd hoe u VBA kunt gebruiken om meerdere Excel-bestanden in \u00e9\u00e9n te combineren.","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:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe meerdere Excel-werkmappen combineren via VBA?","og_description":"In deze zelfstudie wordt uitgelegd hoe u VBA kunt gebruiken om meerdere Excel-bestanden in \u00e9\u00e9n te combineren.","og_url":"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/","url":"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/","name":"\u25b7 Hoe meerdere Excel-werkmappen combineren via VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png","datePublished":"2023-11-17T10:49:24+00:00","dateModified":"2023-12-06T05:50:24+00:00","description":"In deze zelfstudie wordt uitgelegd hoe u VBA kunt gebruiken om meerdere Excel-bestanden in \u00e9\u00e9n te combineren.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/werkmappen-combineren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe meerdere excel-werkmappen combineren met vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1546","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1546"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1546\/revisions"}],"predecessor-version":[{"id":2722,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1546\/revisions\/2722"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}