我在Excel中从vba调用python脚本时遇到问题。我阅读了解决相同问题的其他线程,但当我运行代码时,Python屏幕闪烁,然后消失。仅供参考,我下载了适用于Windows 10的python 3.6.5并将其添加到PATH中。谁能告诉我为什么屏幕会闪烁,我能做些什么来解决这个问题?谢谢
Sub Run_python()
Dim Ret_Val
Dim args As String
args = "C:\Users\opera\AppData\Local\Programs\Python\Python36\Tools\scripts\db2pickle.py"
Ret_Val = Shell("C:\Users\opera\AppData\Local\Programs\Python\Python36\python.exe" & " " & args, vbNormalFocus)
If Ret_Val = 0 Then
MsgBox "Couldn't run python script!", vbOKOnly
End If
End Sub
https://stackoverflow.com/questions/50805511
复制相似问题