VBAでPython3 - Qiita

まずはpythonの用意 純正でも、コンダでも、embedでも pythonの実行環境を作る 次に、VBAの準備 標準モジュールに Option Explicit ' シェルの実行 Public Function run(ByVal cmd As String) As Variant Dim WSH, wExec As Object Set WSH = CreateObject("WScript.Shell") '実行 'Set wExec = WSh.Exec("%ComSpec% /c " & cmd) Set wExec = WSH.exec(cmd) '実行結果 Dim Result, Err wExec.StdIn.WriteLine "echo 処理中" Result = wExec.StdOut.ReadAll Err = wExec.StdErr.ReadAll If Er