Hi Pat,

I am not good at Excel VBA but you may find something useful here:

ZOS-API & Excel interactive extension example- retrieve incident angles on surfaces across pupil | Zemax Community

I made a summary about the materials available on community, sorry it’s in Chinese. You can use browser to translate.

ZOSAPI Excel资料合集 | Zemax Community

Hi Yuan,

Thanks for the link.  I used the same syntax as was in the link (see below) which is nearly the same as my original post and I get the same error message.

Hi Pat,

I ran into some issues to reproduce your situation. I will get to you soon.

Yuan,

I have been able to get my VBA code to run without error messages but I’m still having issues as it doesn’t seem to be running properly in Extension mode.  I can run the code even without an instance of OpticStudio running.  It almost appears to be running in Standalone mode.

I tried using Julia’s code for the incident angles calculation and I had the same problem … the VBA codes runs without errors even when there is no OpticStudio running.

I’ve tried the same code in Matlab and I do not have this problem … it seems to be running properly in Extension mode.

Thanks for your time.

Hi Pat,

Sorry I still have problem in finding my ZOSAPI.dll in Excel...

Hi @Patrick.Cronkite 

I tried the excel sheet from this example: 

When I open OpticStudio, click Interactive Extension then click the Connect button of the macro. It connects.

If I close OpticStudio, click the Connect button of the macro then I get an error message as below.

Could you just run this test?

I can see that your code is very similar but just trying to understand what is different.