Subscribe for automatic updates: RSS icon RSS

Login icon Sign in for full access | Help icon Help
Advanced search

Pages: [1]
  Reply  |  Print  
Author Topic: Check for open excel application  (Read 8845 times)
.
Posts: 20


« 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
Reuben B.
Four Js
Posts: 1046


« Reply #1 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. 

Product Consultant (Asia Pacific)
Developer Relations Manager (Worldwide)
Author of https://4js.com/ask-reuben
Contributor to https://github.com/FourjsGenero
.
Posts: 20


« Reply #2 on: November 24, 2008, 10:11:13 am »

Thanks Reuben.
Pages: [1]
  Reply  |  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines