打开带密码的 word excel 增加 vbs 打开

import win32com.client
word = win32com.client.Dispatch("Word.Application")


file_path = r"C:\Users\password.docx"
file_path2 = r"C:\Users\password2.docx"
password = "123"
# xlwb = word.Documents.Open(file_path, False, True, None, password)

file_list = [file_path, file_path2]

for file in file_list:
    xlwb = word.Documents.Open(file, False, True, None, password)

打开 excel

from xlrd import *
import win32com.client
import csv
import sys

xlApp = win32com.client.Dispatch("Excel.Application")

xlwb = xlApp.Workbooks.Open(filename, False, True, None, password)

vbs 实现

Dim ObjWD,ObjXL
Set ObjWD = CreateObject("Word.Application")
ObjWD.Visible = true
Set ObjXL = CreateObject("Excel.Application")
ObjXL.Visible = true

password = "123"
ObjWD.Documents.Open "d:\121.docx", , , , password & ""
ObjWD.Documents.Open "d:\122.docx", , , , password & ""
ObjXL.Workbooks.Open "d:\123.xlsx", , , , password & ""

参考
https://stackoverflow.com/questions/19450837/how-to-open-a-password-protected-excel-file-using-python