{"id":19581,"date":"2025-06-27T16:02:47","date_gmt":"2025-06-27T08:02:47","guid":{"rendered":"https:\/\/newsletter.tcu.edu.tw\/?p=19581"},"modified":"2025-06-27T16:02:47","modified_gmt":"2025-06-27T08:02:47","slug":"chatgpt%e5%8a%a9%e5%8a%9b-excel-x-vba%e8%87%aa%e5%8b%95%e5%8c%96%e8%bc%95%e9%ac%86%e4%b8%8a%e6%89%8b","status":"publish","type":"post","link":"https:\/\/newsletter.tcu.edu.tw\/?p=19581","title":{"rendered":"ChatGPT\u52a9\u529b  Excel \u00d7 VBA\u81ea\u52d5\u5316\u8f15\u9b06\u4e0a\u624b"},"content":{"rendered":"<p class=\"p1\"><span class=\"s1\">\u6587\uff0f\u7167\u7247\uff1a\u96fb\u7b97\u4e2d\u5fc3 \u6559\u5b78\u652f\u63f4\u7d44<\/span><\/p>\n<p class=\"p2\"><span class=\"s1\">\u70ba\u5f37\u5316\u672c\u6821\u6559\u8077\u54e1\u6578\u4f4d\u61c9\u7528\u80fd\u529b\uff0c\u63a8\u52d5\u884c\u653f\u6548\u80fd\u8207\u667a\u6167\u5316\u670d\u52d9\uff0c\u96fb\u7b97\u4e2d\u5fc3\u65bc 114 \u5e74 5 \u6708 23 \u65e5\u8fa6\u7406\u300cAI \u5de5\u4f5c\u6d41\u81ea\u52d5\u5316\u300d\u6559\u80b2\u8a13\u7df4\u8ab2\u7a0b\u3002\u6b64\u6b21\u8ab2\u7a0b\u4ee5\u300cAI \u52a9\u529b\uff0cExcel \u5347\u7d1a\u300d\u70ba\u4e3b\u984c\uff0c\u805a\u7126\u5982\u4f55\u904b\u7528 ChatGPT \u5354\u52a9\u64b0\u5beb\u516c\u5f0f\u8207 VBA \u7a0b\u5f0f\uff0c\u7d50\u5408\u5be6\u52d9\u6848\u4f8b\u64cd\u4f5c\uff0c\u5354\u52a9\u5b78\u54e1\u7c21\u5316\u91cd\u8907\u4f5c\u696d\u6d41\u7a0b\u3001\u63d0\u5347\u8cc7\u6599\u8655\u7406\u6548\u7387\u3002\u5171\u8a08 62 \u4f4d\u540c\u4ec1\u53c3\u8207\uff0c\u56de\u994b\u8e34\u8e8d\uff0c\u8ab2\u7a0b\u6574\u9ad4\u7372\u5f97\u9ad8\u5ea6\u80af\u5b9a\u3002<\/span><\/p>\n<p class=\"p2\"><span class=\"s1\">\u8ab2\u7a0b\u5167\u5bb9\u5206\u70ba\u5169\u5927\u4e3b\u984c\u9032\u884c\uff0c\u7b2c\u4e00\u90e8\u5206\u70ba Excel \u81ea\u52d5\u5316\u61c9\u7528\uff0c\u9080\u8acb\u67e5\u7279\u666e\u62c9\u65af\u7ba1\u7406\u9867\u554f\u6709\u9650\u516c\u53f8\uff0c\u5433\u627f\u7a4e\u8b1b\u5e2b\u6388\u8ab2\u3002\u8b1b\u5e2b\u73fe\u4efb 1111 \u4eba\u529b\u9280\u884c\u751f\u6210\u5f0f AI \u5275\u65b0\u5b78\u9662\u9867\u554f\uff0c\u4ea6\u64d4\u4efb\u591a\u5bb6\u8edf\u9ad4\u65b0\u5275\u516c\u53f8 ChatGPT \u5206\u6790\u9867\u554f\uff0c\u4e26\u5171\u540c\u51fa\u7248\u300aChatGPT \u4e2d\u6587\u5be6\u6230\u6307\u5357\u300b\uff0c\u5be6\u52d9\u8207\u6559\u5b78\u7d93\u9a57\u8c50\u5bcc\u3002\u8ab2\u7a0b\u7531\u57fa\u790e\u6982\u5ff5\u51fa\u767c\uff0c\u8aaa\u660e\u6b04\u4f4d\u53c3\u7167\u3001\u516c\u5f0f\u7d50\u69cb\u8207\u689d\u4ef6\u5f0f\u8a2d\u5b9a\u7b49\u91cd\u9ede\uff0c\u9032\u800c\u900f\u904e ChatGPT \u751f\u6210\u9032\u968e\u516c\u5f0f\u3002\u642d\u914d\u5be6\u4f5c\u6848\u4f8b\uff0c\u5305\u542b\u8de8\u8868\u6574\u5408\u3001\u7d71\u8a08\u5831\u8868\u3001\u8907\u96dc\u67e5\u8a62\u7b49\uff0c\u4e26\u50b3\u6388\u4e5d\u5927\u95dc\u9375\u6307\u4ee4\u8207\u4e03\u9805\u9664\u932f\u6280\u5de7\uff0c\u8b93\u540c\u4ec1\u5b78\u6703\u5982\u4f55\u6e05\u695a\u63cf\u8ff0\u554f\u984c\u3001\u5f15\u5c0e AI \u63d0\u4f9b\u7cbe\u6e96\u89e3\u6cd5\uff0c\u6709\u6548\u89e3\u6c7a\u5de5\u4f5c\u4e2d\u5e38\u898b\u7684\u8cc7\u6599\u8655\u7406\u6311\u6230\u3002<\/span><\/p>\n<p class=\"p2\"><span class=\"s1\">\u7b2c\u4e8c\u90e8\u5206\u539f\u9810\u8a08\u4ecb\u7d39 Google Apps Script\uff08GAS\uff09\u61c9\u7528\uff0c\u73fe\u5834\u591a\u6578\u540c\u4ec1\u53cd\u6620\u65e5\u5e38\u4ecd\u4ee5 Excel \u70ba\u4e3b\uff0c\u8b1b\u5e2b\u5373\u6642\u8abf\u6574\u5167\u5bb9\uff0c\u6539\u4ee5 VBA \u70ba\u6838\u5fc3\uff0c\u9032\u884c\u7a0b\u5f0f\u64b0\u5beb\u8207\u61c9\u7528\u5be6\u4f5c\u3002\u8ab2\u7a0b\u4e2d\u900f\u904e ChatGPT \u5354\u52a9\u751f\u6210 VBA \u7a0b\u5f0f\u78bc\uff0c\u5e36\u9818\u540c\u4ec1\u5b8c\u6210\u300cExcel \u540d\u55ae\u8f49\u63db\u5927\u91cf\u5bc4\u4fe1\u300d\u3001\u300c\u8349\u7a3f\u81ea\u52d5\u751f\u6210\u300d\u3001\u300c\u81ea\u52d5\u532f\u51fa\u8cc7\u6599\u300d\u7b49\u7bc4\u4f8b\u64cd\u4f5c\u3002\u8b1b\u5e2b\u4e26\u5f15\u5c0e\u540c\u4ec1\u5efa\u7acb\u7a0b\u5f0f\u908f\u8f2f\u601d\u8003\u6d41\u7a0b\uff0c\u900f\u904e\u300c\u89d2\u8272\u626e\u6f14\u6307\u4ee4\u300d\u3001\u300c\u601d\u8003\u93c8\u6a21\u677f\u300d\u8207\u300c\u932f\u8aa4\u6392\u9664\u8a9e\u53e5\u300d\uff0c\u5f37\u5316\u5c0d\u81ea\u52d5\u5316\u6d41\u7a0b\u8a2d\u8a08\u7684\u7406\u89e3\uff0c\u5373\u4f7f\u7121\u7a0b\u5f0f\u57fa\u790e\u4ea6\u80fd\u9010\u6b65\u4e0a\u624b\u3002<\/span><\/p>\n<p class=\"p2\"><span class=\"s1\">\u6839\u64da\u8ab2\u5f8c\u554f\u5377\u7d50\u679c\u986f\u793a\uff0c\u8ab2\u7a0b\u5728\u300c\u662f\u5426\u6709\u6548\u63d0\u5347\u884c\u653f\u6548\u7387\u300d\u53ca\u300c\u6574\u9ad4\u6eff\u610f\u5ea6\u300d\u5169\u9805\u6307\u6a19\u7686\u9054 9.7 \u5206\uff08\u6eff\u5206 10 \u5206\uff09\u3002\u903e\u4e5d\u6210\u540c\u4ec1\u8a8d\u70ba\u8ab2\u7a0b\u6559\u6750\u5167\u5bb9\u5be6\u7528\uff0c\u7bc4\u4f8b\u8cbc\u8fd1\u5be6\u52d9\uff0c\u4e26\u80fd\u6709\u6548\u7c21\u5316\u65e5\u5e38\u884c\u653f\u4f5c\u696d\u3002\u7279\u5225\u662f\u5728 ChatGPT \u8207 Excel \u7d50\u5408\u751f\u6210\u516c\u5f0f\u3001\u61c9\u7528 VBA \u5be6\u4f5c\u5927\u91cf\u5bc4\u4fe1\u3001\u719f\u6089\u5982\u4f55\u4e0b\u6307\u4ee4\u8207 debug \u6280\u5de7\u7b49\u4e3b\u984c\uff0c\u6df1\u7372\u540c\u4ec1\u597d\u8a55\u3002\u4e0d\u5c11\u540c\u4ec1\u8868\u793a\uff1a\u300c\u539f\u4ee5\u70ba\u516c\u5f0f\u8207 VBA \u5f88\u56f0\u96e3\uff0c\u6c92\u60f3\u5230\u900f\u904e ChatGPT \u5f15\u5c0e\u5c31\u80fd\u5b8c\u6210\uff0c\u5c0d\u696d\u52d9\u8655\u7406\u4e0a\u5e6b\u52a9\u6975\u5927\u3002\u300d\u8ab2\u7a0b\u4ea6\u6fc0\u767c\u540c\u4ec1\u9032\u4e00\u6b65\u63a2\u7d22 AI \u5de5\u5177\u61c9\u7528\uff0c\u63d0\u5347\u89e3\u6c7a\u554f\u984c\u7684\u4fe1\u5fc3\u8207\u6548\u7387\u3002<\/span><\/p>\n<p class=\"p2\"><span class=\"s1\">\u7d9c\u89c0\u672c\u6b21\u8a13\u7df4\u6210\u679c\uff0c\u540c\u4ec1\u80af\u5b9a\u8b1b\u5e2b\u6559\u5b78\u6e05\u6670\u3001\u4e92\u52d5\u826f\u597d\uff0c\u7d1b\u7d1b\u5efa\u8b70\u6301\u7e8c\u8fa6\u7406\u5be6\u52d9\u5c0e\u5411\u7684\u9032\u968e\u8ab2\u7a0b\uff0c\u4e26\u5efa\u8b70\u672a\u4f86\u82e5\u80fd\u64f4\u5c55\u81f3 Power BI\u3001\u8cc7\u6599\u8996\u89ba\u5316\u7b49\u9818\u57df\uff0c\u5c07\u66f4\u6709\u52a9\u65bc\u8cc7\u6599\u89e3\u8b80\u8207\u5831\u8868\u6c7a\u7b56\u3002\u96fb\u7b97\u4e2d\u5fc3\u5c07\u6301\u7e8c\u8fa6\u7406 AI \u76f8\u95dc\u61c9\u7528\u8ab2\u7a0b\uff0c\u4f9d\u64da\u5be6\u969b\u696d\u52d9\u9700\u6c42\u6efe\u52d5\u5f0f\u898f\u5283\uff0c\u6df1\u5316\u672c\u6821\u6559\u8077\u54e1\u5728\u6578\u64da\u8655\u7406\u3001\u81ea\u52d5\u5316\u5de5\u5177\u8207\u8cc7\u8a0a\u5b89\u5168\u7684\u6574\u5408\u61c9\u7528\uff0c\u651c\u624b\u6253\u9020\u9ad8\u6548\u7387\u3001\u667a\u6167\u5316\u7684\u6578\u4f4d\u6821\u5712\u74b0\u5883\u3002<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19582\" src=\"https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3930.jpeg\" alt=\"\" width=\"1024\" height=\"683\" srcset=\"https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3930.jpeg 1024w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3930-300x200.jpeg 300w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3930-768x512.jpeg 768w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3930-730x487.jpeg 730w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3930-435x290.jpeg 435w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3930-272x182.jpeg 272w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19583\" src=\"https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3932.jpeg\" alt=\"\" width=\"1024\" height=\"683\" srcset=\"https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3932.jpeg 1024w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3932-300x200.jpeg 300w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3932-768x512.jpeg 768w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3932-730x487.jpeg 730w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3932-435x290.jpeg 435w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3932-272x182.jpeg 272w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19584\" src=\"https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3936.jpeg\" alt=\"\" width=\"1024\" height=\"683\" srcset=\"https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3936.jpeg 1024w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3936-300x200.jpeg 300w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3936-768x512.jpeg 768w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3936-730x487.jpeg 730w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3936-435x290.jpeg 435w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3936-272x182.jpeg 272w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19585\" src=\"https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3950.jpeg\" alt=\"\" width=\"1024\" height=\"683\" srcset=\"https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3950.jpeg 1024w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3950-300x200.jpeg 300w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3950-768x512.jpeg 768w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3950-730x487.jpeg 730w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3950-435x290.jpeg 435w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3950-272x182.jpeg 272w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19586\" src=\"https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3954.jpeg\" alt=\"\" width=\"1024\" height=\"683\" srcset=\"https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3954.jpeg 1024w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3954-300x200.jpeg 300w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3954-768x512.jpeg 768w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3954-730x487.jpeg 730w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3954-435x290.jpeg 435w, https:\/\/newsletter.tcu.edu.tw\/wp-content\/uploads\/2025\/06\/IMG_3954-272x182.jpeg 272w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6587\uff0f\u7167\u7247\uff1a\u96fb\u7b97\u4e2d\u5fc3 \u6559\u5b78\u652f\u63f4\u7d44 \u70ba\u5f37\u5316\u672c\u6821\u6559\u8077\u54e1\u6578\u4f4d\u61c9\u7528\u80fd\u529b [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":19584,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-19581","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-5","clearfix"],"_links":{"self":[{"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=\/wp\/v2\/posts\/19581","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19581"}],"version-history":[{"count":1,"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=\/wp\/v2\/posts\/19581\/revisions"}],"predecessor-version":[{"id":19587,"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=\/wp\/v2\/posts\/19581\/revisions\/19587"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=\/wp\/v2\/media\/19584"}],"wp:attachment":[{"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19581"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/newsletter.tcu.edu.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}