如何用python执行macro_如何使用Python脚本运行Excel宏？

您可以尝试更新注册表中的宏设置以允许所有宏运行。您需要以管理员身份运行Python脚本，或者确保注册表项具有适当的权限：import winreg

import os

import win32com.client

def registry_set_key(hive, regpath, key, type, value):

try:

hkey = winreg.OpenKey(hive, regpath, 0, winreg.KEY_ALL_ACCESS)

except FileNotFountError as e:

hkey = winreg.CreateKey(hive, regpath, 0, winreg.KEY_ALL_ACCESS)

try:

old = winreg.QueryValueEx(hkey, key)

except:

old = None

winreg.SetValueEx(hkey, key, 0, type, value)

winreg.CloseKey(hkey)

return old

if os.path.exists(r"C:\\Users\\siddharth.mungekar\\Desktop\\MemleakTest\\test.xlsm"):

# Set macro settings to 1 to allow all macros

old = registry_set_key(winreg.HKEY_CURRENT_USER, r'Software\Microsoft\Office\14.0\Excel\Security', 'VBAWarnings', winreg.REG_DWORD, 1)

xl = win3