Is there any possibility to run instance of Python with loaded specified script from R as I did in VBA below:
Sub Script_Daily_Launcher()
Dim objShell As Object
Dim PythonExe, PythonScript As String
Set objShell = VBA.CreateObject("WScript.Shell")
PythonExe = """path to Python"""
PythonScript = "path to my script"
objShell.Run PythonExe & PythonScript, , True
ActiveWorkbook.RefreshAll
End Sub
I have heard about reticulate package but it is running Python inside R and I just want something more easier to just call Python instance directly from R. Thanks in advance for any help.