Skip to main content
 首页 » 编程设计

python之从 VBA 调用 python 脚本

2025年02月15日10pengyingh

似乎有很多关于这个的线程,它们都指向这个解决方案:

Function call_py() 
 
Dim rv As Variant 
Const pypath = "C:\Users\user\AppData\Local\Programs\Python\Python36-32\python.exe " 
Const scriptpath = "c:\Users\user\Desktop\test.py" 
 
    rv = Shell(pypath & scriptpath, vbNormalFocus) 
 
 
End Function 

或类似的东西。不过,所有这一切都是在不执行脚本的情况下使 shell 弹出和消失。我做错了什么?

P.

请您参考如下方法:

试试这个:

Sub bat() 
Dim batch, fso As Object 
Dim path As String 
path = "c:\Users\user\Desktop\" 
 
Set fso = CreateObject("Scripting.FileSystemObject") 
Set batch = fso.CreateTextFile(path & "python.bat", True) 
batch.writeline "cd " & path 
batch.writeline "python test.py" 
batch.Close 
 
Shell path & "python.bat", 1 
End Sub