{"id":5482,"date":"2024-12-16T02:46:55","date_gmt":"2024-12-16T02:46:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/cach-xoa-file-trong-folder-bang-vba\/"},"modified":"2024-12-16T02:46:55","modified_gmt":"2024-12-16T02:46:55","slug":"cach-xoa-file-trong-folder-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/cach-xoa-file-trong-folder-bang-vba\/","title":{"rendered":"C\u00e1ch x\u00f3a file trong folder b\u1eb1ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch\u00a0\u1ee9ng d\u1ee5ng VBA trong vi\u1ec7c\u00a0x\u00f3a\u00a0c\u00e1c n\u1ed9i\u00a0 dung trong m\u1ed9t th\u01b0 m\u1ee5c tr\u00ean m\u00e1y t\u00ednh. Vi\u1ec7c n\u00e0y r\u1ea5t h\u1eefu d\u1ee5ng khi ch\u00fang ta th\u01b0\u1eddng xuy\u00ean ph\u1ea3i t\u01b0\u01a1ng t\u00e1c tr\u00ean\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng th\u01b0 m\u1ee5c trong VBA, thay v\u00ec x\u00f3a b\u1eb1ng tay t\u1eebng m\u1ee5c th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng VBA\u00a0\u0111\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c n\u1ed9i dung trong th\u01b0 m\u1ee5c\u00a0\u0111\u00f3.\u00a0\u0110\u1eb7c bi\u1ec7t h\u1eefu\u00a0\u00edch khi l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng c\u00f4ng vi\u1ec7c c\u00f3 s\u1eed d\u1ee5ng l\u1ec7nh\u00a0 tr\u00edch\u00a0 xu\u1ea5t n\u1ed9i dung ra nhi\u1ec1u file n\u1eb1m trong c\u00f9ng 1 th\u01b0 m\u1ee5c.<\/p>\n<p>Tham kh\u1ea3o b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/lenh-trich-xuat-du-lieu-hang-loat-ra-file-pdf-theo-moi-doi-tuong.html\">L\u1ec7nh tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u h\u00e0ng lo\u1ea1t ra file PDF theo m\u1ed7i \u0111\u1ed1i t\u01b0\u1ee3ng<\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-675f949ecf57a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-xoa-file-trong-folder-bang-vba.html#1_Nguyen_tac_thuc_hien\" title=\"1. Nguy\u00ean t\u1eafc th\u1ef1c hi\u1ec7n\">1. Nguy\u00ean t\u1eafc th\u1ef1c hi\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-xoa-file-trong-folder-bang-vba.html#2_Cau_lenh_VBA\" title=\"2. C\u00e2u l\u1ec7nh VBA\">2. C\u00e2u l\u1ec7nh VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Nguyen_tac_thuc_hien\"><\/span>1. Nguy\u00ean t\u1eafc th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta c\u1ea7n l\u00e0m vi\u1ec7c theo 2\u00a0\u0111\u1ed1i\u00a0 t\u01b0\u1ee3ng ch\u00ednh:<\/p>\n<ul>\n<li>Th\u01b0 m\u1ee5c: X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u00fang\u00a0\u0111\u01b0\u1eddng d\u1eabn t\u1edbi th\u01b0 m\u1ee5c\u00a0\u0111\u00f3<\/li>\n<li>C\u00e1c file trong th\u01b0 m\u1ee5c: M\u1ed7i file\u00a0\u0111\u1ec1u c\u00f3 1\u00a0\u0111i\u1ec3m chung l\u00e0 c\u00f3 d\u1ea5u\u00a0 ch\u1ea5m (th\u1ec3 hi\u1ec7n\u00a0\u0111u\u00f4i file\u00a0\u0111\u00f3 l\u00e0 d\u1ea1ng file n\u00e0o).<\/li>\n<\/ul>\n<p><strong>Ch\u00fa\u00a0\u00fd:<\/strong><\/p>\n<ul>\n<li>C\u1ea7n ki\u1ec3m tra xem trong th\u01b0 m\u1ee5c c\u00f3 file n\u00e0o kh\u00f4ng, v\u00ec n\u1ebfu kh\u00f4ng ch\u1ee9a file th\u00ec kh\u00f4ng c\u1ea7n th\u1ef1c hi\u1ec7n thao t\u00e1c x\u00f3a.<\/li>\n<li>Sau khi ho\u00e0n th\u00e0nh l\u1ec7nh\u00a0 x\u00f3a c\u00e1c th\u01b0 m\u1ee5c c\u1ea7n c\u00f3 th\u00f4ng b\u00e1o\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh,\u00a0\u0111\u1ec3 nh\u1eafc cho ch\u00fang ta bi\u1ebft c\u00e2u l\u1ec7nh\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"2_Cau_lenh_VBA\"><\/span>2. C\u00e2u l\u1ec7nh VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/aac26c5a3926f8391eaa54e64598dceb\">Gist<\/a>.<\/div>\n<p>Trong c\u00e2u l\u1ec7nh tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp vi\u1ec7c t\u00f9y ch\u1ecdn\u00a0\u0111\u01b0\u1eddng d\u1eabn t\u1edbi th\u01b0 m\u1ee5c c\u1ea7n x\u00f3a n\u1ebfu ch\u01b0a r\u00f5\u00a0\u0111\u01b0\u1eddng d\u1eabn ch\u00ednh x\u00e1c, nh\u01b0 v\u1eady c\u00f3 th\u1ec3 l\u00e0m ch\u1eadm th\u1ee7 t\u1ee5c nh\u01b0ng s\u1ebd t\u0103ng t\u00ednh ch\u00ednh x\u00e1c.<\/p>\n<p>L\u01b0u\u00a0\u00fd:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-194.gif\" title=\"vba101_92019-nho-194\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-474.gif\" title=\"ex101_92019-nho-474\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Vi\u1ec7c x\u00f3a file trong Folder b\u1eb1ng c\u00e2u l\u1ec7nh tr\u00ean c\u1ea7n l\u01b0u\u00a0\u00fd: X\u00f3a t\u1ea5t c\u1ea3 c\u00e1c file, kh\u00f4ng ph\u00e2n bi\u1ec7t lo\u1ea1i file l\u00e0 g\u00ec.<\/p>\n<p>Mu\u1ed1n x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5 lo\u1ea1i file c\u1ea7n x\u00f3a, c\u1ea7n t\u00f9y bi\u1ebfn l\u1ea1i n\u1ed9i dung *.* th\u00e0nh *.\u0111u\u00f4i file<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-194.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5483,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5482","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=5482"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5482\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5483"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}