Running Julia scripts from excel VBA

General Usage
6

Just to let everyone know the following VBA code worked for runnining a julia script from excel (VBA)

Sub Run_Julia()

Dim objShell As Object
Dim Julia_Script, Julia_Exe As String

Set objShell = VBA.CreateObject("WScript.Shell")

Julia_Exe = """C:\Users\peter\AppData\Local\Programs\Julia 1.5.3\bin\julia.exe"""
Julia_Script = "C:\Users\peter\Documents\Julia_Code\Greenhouse_Model\Green-Lights-main\test.jl"
objShell.Run Julia_Exe & Julia_Script
 
Set objShell = Nothing

End Sub

Case closed!