<p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong><span style="font-size:16pt">VB程式</span></strong></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://hwarnder.pixnet.net/blog/post/121843187" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank"> 1. 中心計帳收集</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> <a href="https://blog.xuite.net/hwarnder/program/400347223" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank"> 中心計帳後，存摺備註資料出現亂碼的原因，如何避免？</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61299051" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">2. 甲存中心計帳作業</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61298485" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">3. 機關委農會轉帳程式</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61301038" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">4. 承辦人收發公文歸檔作業</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61301335" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">5. 個人常用信封列印</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61301542" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">6. 通匯信封</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61302305" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">7. 從DPS本文檔中篩選以及截取篩選後之本文檔</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61321536" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">8. 在本文檔每筆資料之逗點與逗點處插入一個空白</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61329501" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">9. 寄發通告給放款戶作業程式</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61338519" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">10. 逾期放款催收資料合併與催收卡列印作業</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61531861" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">11. 放款催收案件追蹤記錄作業</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/63718367" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">12. 催收與呆帳所衍生的相關費用作業</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61531559" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">13. 將規律性多行為一筆資料之本文檔重組成一行</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> </p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong><span style="font-size:16pt">BCB程式</span></strong></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://hwarnder.pixnet.net/blog/post/121896584" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">1. 註冊費暨午餐費委農會扣繳作業程式</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><a href="https://blog.xuite.net/hwarnder/program/61301467" style="color: rgb(56, 61, 36); text-decoration: none;" target="_blank">2. 電腦匯款單列印作業</a></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> </p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong><span style="font-size:20px">EXCEL VBA</span></strong></p> <p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(202, 192, 149); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">1.<a href="https://hwarnder.pixnet.net/blog/post/121896611" target="_blank">Excel資料轉成中心計帳媒體檔之VBA程式 108.08.30更版</a></p>
小程式及工具 (1)