在Python中执行Visual Basic宏(从个人宏工作簿)

import win32com.client

def run_vba_macro():
    excel = win32com.client.Dispatch("Excel.Application")
    excel.Visible = False  # 设置Excel应用程序不可见

    try:
        workbook = excel.Workbooks.Open(r"path_to_workbook.xlsm")  # 打开包含宏的工作簿
        workbook.Application.Run("Personal.xlsb!Module1.MacroName")  # 执行宏
        workbook.Save()  # 保存工作簿
    except Exception as e:
        print("执行宏时出错:", str(e))
    finally:
        workbook.Close()  # 关闭工作簿
        excel.Quit()  # 退出Excel应用程序

run_vba_macro()