{"id":58,"date":"2010-12-08T12:55:03","date_gmt":"2010-12-08T11:55:03","guid":{"rendered":"http:\/\/mariaevert.dk\/vba\/?p=58"},"modified":"2010-12-08T12:55:23","modified_gmt":"2010-12-08T11:55:23","slug":"vba-delete-all-files-in-a-folder","status":"publish","type":"post","link":"https:\/\/mariaevert.dk\/vba\/?p=58","title":{"rendered":"VBA &#8211; Delete all files in a folder"},"content":{"rendered":"<p>This code snippet shows how you can delete all files in a given folder in a VBA application. <\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">\r\nSub deleteFiles()\r\ndim myPath\r\nmyFolder = &quot;C:\\MyFolder1\\Myfolder2&quot;      \r\nSet Fso = CreateObject(&quot;Scripting.FileSystemObject&quot;) ' Get a File object to query.\r\nSet Fldr = Fso.GetFolder(myFolder)\r\n                \r\nFor Each Filename In Fldr.Files\r\n    Filename.Delete True ' delete all files\r\nNext\r\nEnd Sub\r\n<\/pre>\n<p>That&#8217;s it!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This code snippet shows how you can delete all files in a given folder in a VBA application. That&#8217;s it!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/posts\/58"}],"collection":[{"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=58"}],"version-history":[{"count":3,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/posts\/58\/revisions"}],"predecessor-version":[{"id":61,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/posts\/58\/revisions\/61"}],"wp:attachment":[{"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}