開啟巨集方式:按下 Alt + F11 開啟VBA編輯器,點選「插入」(Insert) > 「模組」(Module)
EXCEL要修改Office設定,啟用VBA巨集: 【檔案-選項-信任中心-信任中心設定-巨集設定-啟用VBA巨集】
How to open macros: Press Alt + F11 to open the VBA editor, then click "Insert" > "Module"
To enable VBA macros in EXCEL, modify Office settings: [File - Options - Trust Center - Trust Center Settings - Macro Settings - Enable VBA Macros]
Sub ApplyTableStyleToAllTables()
Dim tbl As Table
' 指定要套用的表格樣式名稱
Dim styleToApply As String
styleToApply = "表格格線" ' 這裡可以更改為您想要的表格樣式名稱
' 對文件中的每個表格套用相同的樣式
For Each tbl In ActiveDocument.Tables
tbl.Style = styleToApply
Next tbl
MsgBox "所有表格已套用 " & styleToApply & " 樣式!", vbInformation
End Sub
https://drive.google.com/file/d/1DrL8_O5JNgdC0n2ZRvKllKjPScYAlHdU/view?usp=sharing
公式範例: =URLEncodeutf8(A2)
會把A2欄位內的中文【寫程式】
轉為 【%E5%AF%AB%E7%A8%8B%E5%BC%8F】
網址格式
Function URLEncode(ByVal strText As String) As String
Dim i As Integer
Dim acode As Integer
Dim char As String
URLEncode = ""
For i = 1 To Len(strText)
char = Mid(strText, i, 1)
acode = Asc(char)
Select Case acode
Case 48 To 57, 65 To 90, 97 To 122 ' 0-9, A-Z, a-z
URLEncode = URLEncode & char
Case 32 ' 空格
URLEncode = URLEncode & "+"
Case Else
URLEncode = URLEncode & "%" & Hex(acode)
End Select
Next i
End Function