Hello,

This sample code demonstrates how to change the settings and then run an analysis from Excel API.
The example below uses the Single Ray Trace:

Dim SRT As IA_
Dim SRT_settings As IAS_RayTrace
Set SRT = TheSystem.Analyses.New_RayTrace()
Set SRT_settings = SRT.GetSettings
SRT_settings.Px = 0.5
SRT_settings.Py = 0.5
SRT_settings.Wavelength.SetWavelengthNumber (2)
SRT_settings.Field.SetFieldNumber (2)
SRT.ApplyAndWaitForCompletion