【EXCEL】- VBA - 取得本身的檔案名稱

⬛ 問題：EXCEL - VBA - 如何取得本身的檔案名稱？

(adsbygoogle = window.adsbygoogle || []).push({});

⬛ 回答：

範例如下

Sub 取得本身的檔案名稱-1( )

Application.ActiveWorkbook.FullName

End Sub

Sub 取得本身的檔案名稱-2( )

Application.ActiveWorkbook.FullName

End Sub

(adsbygoogle = window.adsbygoogle || []).push({});

<h2 class="ih-heading" style="margin: 0px 0px 15px; padding: 0px; border-width: 0px 0px 2px 2px; border-top-style: initial; border-right-style: initial; border-bottom-style: solid; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(2, 141, 99); border-left-color: rgb(2, 141, 99); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: normal; font-stretch: inherit; font-size: 18px; line-height: 1; font-family: inherit; vertical-align: baseline; letter-spacing: 0.7px; background-color: rgb(255, 255, 255);"> 延伸閱讀

<p style="margin: 1em 0px; padding: 0px; border: 0px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 1.1rem; line-height: 1.75rem; font-family: "Noto Sans TC", 微軟正黑體, sans-serif; vertical-align: baseline; color: rgb(52, 52, 52); letter-spacing: 1px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; background-color: rgb(255, 255, 255);"> ■ EXCEL VBA 相關文章🔍

隨手記錄