{"id":8196,"date":"2024-12-22T04:11:29","date_gmt":"2024-12-22T04:11:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/macro-gop-nhieu-files-excel-vao-1-file\/"},"modified":"2024-12-22T04:11:29","modified_gmt":"2024-12-22T04:11:29","slug":"macro-gop-nhieu-files-excel-vao-1-file","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/macro-gop-nhieu-files-excel-vao-1-file\/","title":{"rendered":"Macro g\u1ed9p nhi\u1ec1u files Excel v\u00e0o 1 file"},"content":{"rendered":"
\n

Khi t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 nhu c\u1ea7u t\u1ed5ng h\u1ee3p nhi\u1ec1u file Excel v\u00e0o 1 file duy nh\u1ea5t \u0111\u1ec3 l\u00e0m b\u00e1o c\u00e1o. Vi\u1ec7c m\u1edf t\u1eebng file ra copy s\u1ebd r\u1ea5t t\u1ed1n c\u00f4ng s\u1ee9c v\u00e0 th\u1eddi gian. \u0110\u00e2y l\u00e0 1 b\u00e0i to\u00e1n l\u00fd t\u01b0\u1edfng cho VBA hay Macro trong Excel c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ho\u00e0n th\u00e0nh 1 c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n

Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 3 files v\u1edbi c\u1ea5u tr\u00fac gi\u1ed1ng nhau v\u00e0 ch\u1ec9 kh\u00e1c nhau v\u1ec1 d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n

<\/a><\/p>\n

Ch\u00fang ta s\u1ebd t\u1ed5ng h\u1ee3p 3 files Book1.xlsx,Book2.xlsx v\u00e0 Book3.xlsx v\u00e0o 1 file c\u00f3 t\u00ean l\u00e0 Tong hop.xlsm. Ngh\u0129a l\u00e0 d\u1eef li\u1ec7u \u1edf trong Book1, \u0111\u01b0\u1ee3c l\u01b0u \u1edf Sheet1, d\u1eef li\u1ec7u \u1edf trong Book2 c\u0169ng \u0111\u01b0\u1ee3c l\u01b0u m\u1eb7c \u0111\u1ecbnh \u1edf Sheet1, t\u01b0\u01a1ng t\u1ef1 v\u1edbi Book3:<\/p>\n

\n

Kh\u00f3a h\u1ecdc Word Excel<\/a>\u00a0v\u1edbi c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\n

B\u01b0\u1edbc 1<\/strong>: M\u1edf file Tong hop.xlsm<\/p>\n

B\u01b0\u1edbc 2<\/strong>: B\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm ALT + F11<\/strong> \u0111\u1ec3 m\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA<\/p>\n

\"cach-mo-trinh-soan-thao-vba\"<\/a><\/p>\n

B\u01b0\u1edbc 3<\/strong>: M\u1edf Project Explorer: B\u1ea5m v\u00e0o View > Project Explorer<\/strong><\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

\"M\u1edf<\/a><\/p>\n

B\u01b0\u1edbc 4<\/strong>: Trong c\u1eeda s\u1ed5 Project Explorer, t\u1ea1o 1 Module m\u1edbi<\/p>\n

<\/a><\/p>\n

B\u01b0\u1edbc 5<\/strong>: Copy code sau v\u00e0o trong module m\u1edbi v\u1eeba t\u1ea1o ra:<\/p>\n

[sociallocker id=2748]<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n

\u00a0<\/p>\n

B\u01b0\u1edbc 6<\/strong>: B\u1ea5m ph\u00edm F5 \u0111\u1ec3 ch\u1ea1y Sub v\u1eeba t\u1ea1o ra r\u1ed3i sau \u0111\u00f3 ch\u1ecdn files c\u1ea7n t\u1ed5ng h\u1ee3p v\u00e0 b\u1ea5m n\u00fat Open.<\/p>\n

Download to\u00e0n b\u1ed9 file k\u00e8m theo b\u00e0i vi\u1ebft \u0111\u1ec3 th\u1ef1c h\u00e0nh:<\/p>\n

Gop nhieu file vao 1 file<\/a><\/strong><\/p>\n

\u00a0<\/p>\n

VBA\u00a0gi\u00fap \u00edch\u00a0r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 Word, Power Point, Outlook\u2026 gi\u00fap bi\u1ebfn file Excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p\u2026<\/p>\n

\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc\u00a0VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8196","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\/8196","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=8196"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8196\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8197"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}