The following VisualBasic code shows the control of a simple distributed computing simulation with SPRAY. Please read the comments that explain what happens.

Sub dc_test()

Dim nr As Long

Dim seconds, signal As Single

 ' Create the SPRAY Ole server

 Set spray = CreateObject("Spray99.Spray_Remote")

 ' Load the configuration

 spray.load_configuration = "c:/temp/dc_test/dc_test.s99"

 ' Show SPRAY

 spray.Show

 ' Switch off Excel warnings

 ' this avoids the popup message that Excel waits for another application ...

 DisplayAlerts = False

 ' Set the number of rays per spectral point

 spray.photons = 10000

 ' Set the number of rays per task

 spray.dc_rays_per_task = 20000

 ' Start the distributed computing simulation

 spray.start_dc_computation

 ' Wait loop: spray.status is >=0 during the simulation and <0 when the job is finished

  nr = spray.Status

 While nr >= 0

     ' wait for 3 seconds

     Application.Wait Now + TimeSerial(0, 0, 3)

     ' ask SPRAY again

     nr = spray.Status

 Wend

 ' get the time SPRAY needed for the last simulation

 seconds = spray.seconds_last_run

 ' Now you should pick up the results ...

 '.

 '.

 '.

 ' Delete the SPRAY ole server

 Set spray = Nothing

End Sub