{"id":5444,"date":"2024-12-16T02:44:07","date_gmt":"2024-12-16T02:44:07","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/cach-sao-chep-noi-dung-tu-workbook-dang-dong\/"},"modified":"2024-12-16T02:44:07","modified_gmt":"2024-12-16T02:44:07","slug":"cach-sao-chep-noi-dung-tu-workbook-dang-dong","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/cach-sao-chep-noi-dung-tu-workbook-dang-dong\/","title":{"rendered":"C\u00e1ch sao ch\u00e9p n\u1ed9i dung t\u1eeb workbook \u0111ang \u0111\u00f3ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 copy n\u1ed9i dung t\u1eeb 1\u00a0workbook\u00a0\u0111ang\u00a0\u0111\u00f3ng? Ch\u1eafc h\u1eb3n khi l\u00e0m vi\u1ec7c tr\u00ean VBA b\u1ea1n c\u0169ng g\u1eb7p r\u1eafc r\u1ed1i v\u1edbi v\u1ea5n\u00a0\u0111\u1ec1 n\u00e0y. Th\u00f4ng th\u01b0\u1eddng ch\u00fang ta ph\u1ea3i th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y m\u1ed9t c\u00e1ch r\u1ea5t th\u1ee7 c\u00f4ng:<\/p>\n<ul>\n<li>M\u1edf\u00a0workbook ch\u1ee9a n\u1ed9i dung c\u1ea7n copy (Closed\u00a0Workbook)<\/li>\n<li>Th\u1ef1c hi\u1ec7n thao t\u00e1c copy<\/li>\n<li>D\u00e1n n\u1ed9i dung v\u00e0o\u00a0workbook c\u1ea7n l\u1ea5y k\u1ebft qu\u1ea3 (Active\u00a0Workbook)<\/li>\n<li>\u0110\u00f3ng\u00a0workbook ch\u1ee9a n\u1ed9i dung c\u1ea7n copy l\u1ea1i<\/li>\n<\/ul>\n<p>N\u1ebfu nh\u01b0 ch\u00fang ta l\u00e0m vi\u1ec7c\u00a0\u0111\u00f3\u00a0\u0111\u1ed3ng th\u1eddi v\u1edbi nhi\u1ec1u\u00a0workbook th\u00ec s\u1ebd r\u1ea5t m\u1ea5t c\u00f4ng v\u00e0 m\u1ea5t th\u1eddi gian. Sau\u00a0\u0111\u00e2y H\u1ecdc\u00a0Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c\u00a0\u0111\u00f3 tr\u00ean VBA\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng h\u00f3a to\u00e0n b\u1ed9 nh\u1eefng thao t\u00e1c\u00a0\u0111\u00f3.<\/p>\n<p><strong>Nh\u1eefng n\u1ed9i dung c\u1ea7n ch\u00fa\u00a0\u00fd:<\/strong><\/p>\n<ul>\n<li>X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u01b0\u1eddng d\u1eabn t\u1edbi th\u01b0 m\u1ee5c ch\u1ee9a\u00a0workbook c\u1ea7n copy n\u1ed9i dung<\/li>\n<li>X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c v\u00f9ng c\u1ea7n copy<\/li>\n<li>X\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ea7n paste<\/li>\n<li>Vi\u1ec7c m\u1edf v\u00e0\u00a0\u0111\u00f3ng\u00a0workbook s\u1ebd khi\u1ebfn m\u00e0n h\u00ecnh b\u1ecb nh\u1ea5p nh\u00e1y =&gt; th\u1ef1c hi\u1ec7n l\u1ec7nh ng\u0103n vi\u1ec7c\u00a0c\u1eadp nh\u1eadt m\u00e0n h\u00ecnh.<\/li>\n<\/ul>\n<p><strong>C\u00e2u l\u1ec7nh VBA m\u1eabu:<\/strong><\/p>\n<p>D\u01b0\u1edbi\u00a0\u0111\u00e2y l\u00e0 c\u00e2u l\u1ec7nh VBA m\u1eabu th\u1ef1c hi\u1ec7n vi\u1ec7c copy d\u1eef li\u1ec7u t\u1eeb 1\u00a0workbook\u00a0\u0111ang\u00a0\u0111\u00f3ng:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/7c449578ade94177048c6f8cb515ff6e\">Gist<\/a>.<\/div>\n<p><strong>Ph\u00e2n t\u00edch m\u1ed9t s\u1ed1 n\u1ed9i dung c\u1ee7a c\u00e2u l\u1ec7nh:<\/strong><\/p>\n<ul>\n<li>Trong c\u00e2u l\u1ec7nh tr\u00ean, ph\u1ea7n\u00a0\u0110\u01b0\u1eddng d\u1eabn v\u00e0 T\u00ean\u00a0workbook\u00a0\u0111\u01b0\u1ee3c chia ra th\u00e0nh t\u1eebng ph\u1ea7n, khi\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t\u00a0\u0111\u01b0\u1ee3c t\u1eebng\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng n\u00e0y\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n. Khi mu\u1ed1n s\u1eed d\u1ee5ng c\u1ea3 t\u00ean v\u00e0\u00a0\u0111\u1ecba ch\u1ec9 (v\u00ed d\u1ee5 nh\u01b0 khi mu\u1ed1n m\u1edf\u00a0workbook c\u1ea7n c\u00f3\u00a0\u0111\u1ee7 2 th\u00f4ng tin n\u00e0y) th\u00ec ch\u00fang ta ch\u1ec9 c\u1ea7n gh\u00e9p 2 bi\u1ebfn l\u1ea1i l\u00e0\u00a0\u0111\u01b0\u1ee3c.<\/li>\n<li>Vi\u1ec7c copy d\u1eef li\u1ec7u c\u00f3 th\u1ec3 s\u1ebd copy c\u1ea3 c\u00f4ng th\u1ee9c. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u1ea7n th\u00eam 1 b\u01b0\u1edbc lo\u1ea1i b\u1ecf c\u00f4ng th\u1ee9c, ch\u1ec9 l\u1ea5y gi\u00e1 tr\u1ecb r\u1ed3i sau\u00a0\u0111\u00f3 th\u1ef1c hi\u1ec7n l\u1ec7nh copy. Nh\u01b0 v\u1eady s\u1ebd tr\u00e1nh\u00a0\u0111\u01b0\u1ee3c l\u1ed7i tham chi\u1ebfu t\u1edbi sheet kh\u00e1c khi th\u1ef1c hi\u1ec7n l\u1ec7nh copy.<\/li>\n<li>Tuy nhi\u00ean vi\u1ec7c chuy\u1ec3n d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng thu\u1ea7n gi\u00e1 tr\u1ecb s\u1ebd l\u00e0m thay\u00a0\u0111\u1ed5i\u00a0workbook ch\u1ee9a n\u1ed9i dung copy. Do\u00a0\u0111\u00f3 khi\u00a0\u0111\u00f3ng\u00a0workbook\u00a0\u0111\u00f3 ch\u00fang ta kh\u00f4ng n\u00ean k\u1ebft h\u1ee3p v\u1edbi vi\u1ec7c Save =&gt; Ch\u1ecdn False khi th\u1ef1c hi\u1ec7n l\u1ec7nh Close\u00a0Workbook\u00a0\u0111\u1ec3\u00a0\u0111\u00f3ng\u00a0workbook m\u00e0 kh\u00f4ng l\u01b0u.<\/li>\n<\/ul>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/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-192.gif\" title=\"vba101_92019-nho-192\"><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-472.gif\" title=\"ex101_92019-nho-472\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u00e2y m\u1edbi l\u00e0 m\u1ed9t trong r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng c\u1ee7a VBA m\u00e0 b\u1ea1n d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng. VBA ho\u00e0n to\u00e0n x\u1eed l\u00fd \u0111\u01b0\u1ee3c\u00a0nhi\u1ec1u\u00a0d\u1eef li\u1ec7u trong th\u1eddi gian ng\u1eafn, gi\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<p>B\u1ea1n\u00a0tham gia kho\u00e1 h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2OAUBOg\">VBA101 \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 \u0111\u1ec3 \u0111\u01b0\u1ee3c h\u1ecdc v\u1ec1 VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng nh\u00e9. 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<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-192.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5445,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5444","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\/5444","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=5444"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5444\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5445"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}