Controlling ensight with Excel VBA

daizy · May 22, 2017, 07:11

Is there any way that I can operate my ensight (python based programme) by excel VBA coding. How can I get DLL which will act as interface between python script of ensight and VBA?
Is it possible?
I need this as soon as possible because I want to customize ensight in one click , I know the operations I have to do in ensight...
Kindly help!!!

Marina G · May 22, 2017, 11:39

Hi Daizy,

The python API of EnSight is designed to be used only from within EnSight, and not from an other app. In other words, you will be able to run the python scripts to guide EnSight only with commands such as

ensight101 -p my_script.py

You can't launch the scripts from an other application without starting EnSight.

So the best approach for you would be to create your customize scripts, and then run them from the shell / command prompt directly.
Note that if you add the -batch flag, EnSight will run in the background and you won't have its gui popping up.

Hope this helps. Let us know if you want more help or need information.
Best Regards,

Marina Galvagni
CEI Software Support Engineer

May 22, 2017, 07:11	Controlling ensight with Excel VBA	#1
daizy New Member daizy Join Date: Apr 2017 Posts: 8 Rep Power: 9	Is there any way that I can operate my ensight (python based programme) by excel VBA coding. How can I get DLL which will act as interface between python script of ensight and VBA? Is it possible? I need this as soon as possible because I want to customize ensight in one click , I know the operations I have to do in ensight... Kindly help!!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automation - Ensight command	Akshay	EnSight	5	August 8, 2014 09:43
CFD++ vs. Ensight	Gustavo	EnSight	0	August 18, 2013 20:49
Radiation and VBA using Excel	kapo84	OpenFOAM	2	January 21, 2010 07:46
Advanced post-processing (to Excel)	Felix	CFX	4	May 2, 2008 14:30

May 22, 2017, 11:39		#2
Marina G Member Marina Galvagni Join Date: Apr 2014 Location: North Carolina, USA Posts: 58 Rep Power: 12	Hi Daizy, The python API of EnSight is designed to be used only from within EnSight, and not from an other app. In other words, you will be able to run the python scripts to guide EnSight only with commands such as ensight101 -p my_script.py You can't launch the scripts from an other application without starting EnSight. So the best approach for you would be to create your customize scripts, and then run them from the shell / command prompt directly. Note that if you add the -batch flag, EnSight will run in the background and you won't have its gui popping up. Hope this helps. Let us know if you want more help or need information. Best Regards, Marina Galvagni CEI Software Support Engineer