[N.Hohlbein]

Hi there,
I´m trying to create a Excel macro which runs a Python Script in my CFX Simulation to automate simulation processes. The macro should start the Python script in Ansys and wait until it´s finished.

I only found the Shell-function below on the internet. But it doesn´t work. It gives me the error "file don´t found" but the file exists and the path is correct (I tripplechecked it). And aditionally (if I understood the code right) it opens the project everytime again instead just running the Python script and waits.

Does someone of you as an idea for this problem?

Thank You
Best regards
N.Hohlbein


py_path = "E:\Ansys Dateien\Ansys_Excel\updateWB2.py"
wb_path = "E:\Ansys Dateien\Ansys_Excel\ExcelTower1\ExcelTower1.wbpj"
launch_opt = "i"

retval = Shell("""E:\Ansys\ANSYS Inc\v182\Framework\bin\Win64\RunWB2.exe -""" & launch_opt & " -R " & py_path & " -F " & wb_path, vbNormalFocus)