![\"\"](\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/10\/image-25.png\")
<\/figure><\/div>\n\n\n- \n
- M\u1edf file Excel ch\u1ee9a c\u00e1c sheet m\u00e0 b\u1ea1n mu\u1ed1n t\u00e1ch.<\/li>\n\n\n\n
- Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm “Alt + F11” \u0111\u1ec3 m\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o Visual Basic for Applications (VBA).<\/li>\n\n\n\n
- Trong tr\u00ecnh so\u1ea1n th\u1ea3o VBA, ch\u1ecdn “Insert” v\u00e0 ch\u1ecdn “Module” \u0111\u1ec3 t\u1ea1o m\u1ed9t module m\u1edbi.<\/li>\n\n\n\n
- Trong module m\u1edbi, h\u00e3y sao ch\u00e9p v\u00e0 d\u00e1n m\u00e3 sau:<\/li>\n<\/ol>\n\n\n\n
Sub Splitbook()\n'Updateby20140612\nDim xPath As String\nxPath = Application.ActiveWorkbook.Path\nApplication.ScreenUpdating = False\nApplication.DisplayAlerts = False\nFor Each xWs In ThisWorkbook.Sheets\n xWs.Copy\n Application.ActiveWorkbook.SaveAs Filename:=xPath & \"\\\" & xWs.Name & \".xls\"\n Application.ActiveWorkbook.Close False\nNext\nApplication.DisplayAlerts = True\nApplication.ScreenUpdating = True\nEnd Sub<\/code><\/pre>\n\n\n\n- \n
- Thay th\u1ebf
\"xPath\"<\/code> b\u1eb1ng \u0111\u01b0\u1eddng d\u1eabn th\u01b0 m\u1ee5c m\u00e0 b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c file Excel m\u1edbi ho\u1eb7c gi\u1eef nguy\u00ean th\u00ec s\u1ebd l\u01b0u t\u1ea1i v\u1ecb tr\u00ed file hi\u1ec7n t\u1ea1i.<\/li>\n\n\n\n- Nh\u1ea5n “F5” ho\u1eb7c ch\u1ecdn “Run” \u0111\u1ec3 ch\u1ea1y m\u00e3 VBA.<\/li>\n\n\n\n
- C\u00e1c sheet trong file Excel s\u1ebd \u0111\u01b0\u1ee3c t\u00e1ch th\u00e0nh c\u00e1c file Excel ri\u00eang bi\u1ec7t v\u00e0 l\u01b0u trong th\u01b0 m\u1ee5c b\u1ea1n \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh.<\/li>\n<\/ol>\n\n\n
\n![\"\"](\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/10\/image-26.png\")
<\/figure><\/div>\n\n\nCh\u00fa \u00fd r\u1eb1ng tr\u01b0\u1edbc khi ch\u1ea1y m\u00e3 VBA, b\u1ea1n n\u00ean sao l\u01b0u file Excel g\u1ed1c \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o an to\u00e0n d\u1eef li\u1ec7u.<\/p>\n\n\n
![\"\"](\"https:\/\/trannghiait.com\/wp-content\/uploads\/2025\/08\/image-150x150.png\")
<\/div>So S\u00e1nh C\u00e1c Phi\u00ean B\u1ea3n ChatGPT: GPT-4, GPT-4.1, GPT-4o, GPT-4.1 Mini \u2013 \u0110\u00e2u L\u00e0 L\u1ef1a Ch\u1ecdn T\u1ed1t Nh\u1ea5t?<\/a><\/li>\n![\"\"](\"https:\/\/trannghiait.com\/wp-content\/uploads\/2025\/02\/Pi-Network-binance.jpeg-150x150.webp\")
<\/div>Pi Network: C\u00f3 th\u1eadt s\u1ef1 t\u1ed1t nh\u01b0 c\u00e1ch m\u1ecdi ng\u01b0\u1eddi hay n\u00f3i v\u1edbi t\u00f4i?<\/a><\/li>\n![\"\"](\"https:\/\/trannghiait.com\/wp-content\/uploads\/2025\/01\/images-150x150.jpg\")
<\/div>DeepSeek: B\u01b0\u1edbc Ti\u1ebfn M\u1edbi Trong Cu\u1ed9c \u0110ua Tr\u00ed Tu\u1ec7 Nh\u00e2n T\u1ea1o To\u00e0n C\u1ea7u<\/a><\/li>\n![\"\"](\"https:\/\/trannghiait.com\/wp-content\/uploads\/2025\/01\/Capture-150x150.png\")
<\/div>L\u1ed7i No module named ‘moviepy.editor’ khi c\u00e0i \u0111\u1eb7t th\u01b0 vi\u1ec7n tr\u00ean Python<\/a><\/li>\n![\"\"](\"https:\/\/trannghiait.com\/wp-content\/uploads\/2025\/01\/image-150x150.png\")
<\/div>H\u01b0\u1edbng D\u1eabn Chi Ti\u1ebft: C\u00e1ch T\u1ea1o Shortcut T\u1eadp Tin tr\u00ean Windows 10\/11 v\u00e0 L\u1ee3i \u00cdch S\u1eed D\u1ee5ng<\/a><\/li>\n![\"\"](\"https:\/\/trannghiait.com\/wp-content\/uploads\/2024\/12\/image-11-150x150.png\")
<\/div>H\u01af\u1edaNG D\u1eaaN X\u00c1C TH\u1ef0C S\u1ed0 \u0110I\u1ec6N THO\u1ea0I\/CCCD CHO T\u00c0I KHO\u1ea2N FACEBOOK CHI TI\u1ebeT<\/a><\/li>\n![\"\"](\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/Microsoft_Office_Excel_2019\u2013present.svg_-150x150.png\")
<\/div>C\u00e1ch chuy\u1ec3n gi\u00e1 tr\u1ecb c\u00f3 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m sang \u0111\u1ecbnh d\u1ea1ng TEXT kh\u00f4ng b\u1ecb thay \u0111\u1ed5i gi\u00e1 tr\u1ecb<\/a><\/li>\n![\"\"](\"https:\/\/trannghiait.com\/wp-content\/uploads\/2024\/11\/hoi-150x150.jpg\")
<\/div>Nguy c\u01a1 “H\u00f3i” t\u1eeb vi\u1ec7c nh\u1ed5 t\u00f3c b\u1ea1c<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"\u0110\u1ec3 t\u00e1ch nhi\u1ec1u sheet trong m\u1ed9t file Excel th\u00e0nh nhi\u1ec1u file ri\u00eang bi\u1ec7t b\u1eb1ng Visual Basic, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau: Ch\u00fa […]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1069","post","type-post","status-publish","format-standard","hentry","category-tin-tuc"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1069","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=1069"}],"version-history":[{"count":6,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1069\/revisions"}],"predecessor-version":[{"id":1977,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1069\/revisions\/1977"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=1069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=1069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=1069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Thay th\u1ebf