Four Js Development Tools Forum

Discussions by product => Genero BDL => Topic started by: . on November 21, 2008, 09:52:51 am



Title: Check for open excel application
Post by: . on November 21, 2008, 09:52:51 am
Hi

I am opening excel using  CALL UI.INTERFACE.FRONTCALL("STANDARD","EXECUTE",  [lv_excel, 0],[lv_res]).
I want to find out if there is function call that can check if excel is open already before  I try to open it ? I am reading data from a spreedsheet and the application keeps opening another excel instance each time so I would like check if excel is running already  .

Thanks
Bothwell


Title: Re: Check for open excel application
Post by: Reuben B. on November 23, 2008, 10:17:44 pm
Hi

I am opening excel using  CALL UI.INTERFACE.FRONTCALL("STANDARD","EXECUTE",  [lv_excel, 0],[lv_res]).
I want to find out if there is function call that can check if excel is open already before  I try to open it ? I am reading data from a spreedsheet and the application keeps opening another excel instance each time so I would like check if excel is running already  .

Thanks
Bothwell

Create a small script/shell etc in a language the front-end understands e.g. on Windows I'd typically use VB script, and then use FrontCall to execute that script.

Google will typically return a number of potential solutions/techniques.  A quick google search of 'is excel running' returned http://peltiertech.com/Excel/scripts.html which looked a promising starting point. 


Title: Re: Check for open excel application
Post by: . on November 24, 2008, 10:11:13 am
Thanks Reuben.