<h2 class=lexical__h2 dir=ltr><span style=white-space: pre-wrap;>靈感:</span></h2><h3 class=lexical__h3 dir=ltr><span style=white-space: pre-wrap;>此 VBA 是利用 </span><a href=https://www.youtube.com/@meiko1>微課頻道</span></a><span style=white-space: pre-wrap;> 的 </span><a href=https://www.youtube.com/watch?v=bfEJAqgJXPw rel=noreferrer>教學 E98 | Excel工作表,各自轉存成獨立的PDF文件</span></a><span style=white-space: pre-wrap;>,所產生的靈感而設計!</span></h3><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><br></p><h2 class=lexical__h2 dir=ltr><span style=white-space: pre-wrap;>問題:</span></h2><h3 class=lexical__h3 dir=ltr><span style=white-space: pre-wrap;>有時要將多個工作表分別存成【xls檔案】或存成【xlsx檔案】或存成【PDF檔案】時,往往要個別單獨複製、貼上一大串的 VBA 程式碼後,再執行,很不方便!</span></h3><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><br></p><h2 class=lexical__h2 dir=ltr><span style=white-space: pre-wrap;>解決:</span></h2><h3 class=lexical__h3 dir=ltr><span style=white-space: pre-wrap;>現在特地設計把三大串的 VBA 程式碼整合在一起,只要《一個》一大串的程式碼就能達到三種檔案格式的要求,算是【三個願望,一次滿足】囉!請看下面影片操作~</span></h3><p class=lexical__paragraph dir=ltr><span style=white-space: pre-wrap;>( PS:此程式碼也能夠將隱藏的工作表輸出成檔案喔 ~ )</span></p><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><br></p><h2 class=lexical__h2 dir=ltr><span style=white-space: pre-wrap;>影片:</span></h2><div class=lexical__youtube><iframe data-lexical-youtube=CJ6SiygDK-I width=600 height=340 src=https://www.youtube-nocookie.com/embed/CJ6SiygDK-I frameborder=0 allow=accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture allowfullscreen=true title=YouTube video></iframe></div><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><br></p><h2 class=lexical__h2 dir=ltr><b><strong class=lexical__textBold style=white-space: pre-wrap;>彩蛋</strong></b></h2><p class=lexical__paragraph dir=ltr><b> pain, no gain 一分耕耘,一分收穫</strong></b></p><div class=lexical__image center><div class=lexical__imageWrapper><img src=https://d2a6d2ofes041u.cloudfront.net/resize?norotation=true&quality=1&url=https%3A%2F%2Fimages.vocus.cc%2F5a80d413-8572-400c-bd84-61fbee73a887.jpg&width=657&sign=j-gpVQB5HL51OTJIeTWnRu4zcuGZnpc9PydySjbESY8 data-src=https://d2a6d2ofes041u.cloudfront.net/resize?norotation=true&quality=80&url=https%3A%2F%2Fimages.vocus.cc%2F5a80d413-8572-400c-bd84-61fbee73a887.jpg&width=657&sign=5H2VCepzc9-FUA4do5IqghKzf4rO-ukiCM1ZPoTyU6I class=lazy data-original-src=https://images.vocus.cc/5a80d413-8572-400c-bd84-61fbee73a887.jpg data-lowquality=true data-width=657 data-height=526 alt=No pain, no gain></div><div class=captionTheme__wrapper> pain, no gain</p></div></div><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><br></p><h2 class=lexical__h2 dir=ltr><a href=https://drive.google.com/file/d/1NxJkSVnSVZkOSpKFkl5n73PBphZA2eYi/view?usp=sharing rel=noreferrer><span style=white-space: pre-wrap;>檔案下載</span></a></h2><p class=lexical__paragraph dir=ltr><span style=white-space: pre-wrap;>( PS:VBA程式碼裡面也有彩蛋喔~ )</span></p><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><span style=white-space: pre-wrap;>以上就是這次的分享,請持續關注 </span><a href=https://vocus.cc/user/@opa168><span style=white-space: pre-wrap;>我</span></a><span style=white-space: pre-wrap;> 和 </span><a href=https://www.youtube.com/@meiko1/featured>微課頻道</span></a><span style=white-space: pre-wrap;>,謝謝大家 ~</span></p><p class=lexical__paragraph dir=ltr><span style=white-space: pre-wrap;>有任何問題,請到</span><a href=https://vocus.cc/salon/65364e35fd89780001c37d3e rel=noreferrer><span style=white-space: pre-wrap;>【opa的沙龍】</span></a><span style=white-space: pre-wrap;>的</span><a href=https://vocus.cc/salon/65364e35fd89780001c37d3e/room/64dc0952fd89780001455c51?tab=%E5%85%A8%E9%83%A8><span style=white-space: pre-wrap;>【Excel VBA 情境學習】</span></a><span style=white-space: pre-wrap;>一起討論有關 VBA 的問題,或加入 LINE社群 </span><a href=https://line.me/ti/g2/qwf7fPScc78LwQ8B75HdLdhK88NPClKyHZ47wg?utm_source=invitation&utm_medium=link_copy&utm_campaign=default>微課小綠群(粉絲交流群)</span></a><span style=white-space: pre-wrap;>,</span></p><p class=lexical__paragraph dir=ltr><br></p><p class=lexical__paragraph dir=ltr><span style=white-space: pre-wrap;>歡迎您的加入。</span></p><p class=lexical__paragraph dir=ltr><br></p>