[SOLVED][Basic]Open and close an extern applic by the MACROS

[Lazar Botescu]

Hello,

I use an external application (server type) for reading some data by DDE in a BASIC macro.
I need from time to time to close and re-open the server application.
No problem to open the application by SHELL command, but realy I didn't arrive to close it by the macro,. The macro needs to work without an operator survey.
It is a litle data logger from a PLC to a PC. Who needs help to relise such an application I'm redy to help him.
Thank you in advance![/quote]
_________________
AOO3.4 User

[Lazar Botescu]

Hello again,
I found a solution! But if you have another ideea please to let me know.

My solution for closing the external application is to use a batch.bat file (named "stop.bat" in my exemple) with only one line:

taskkill /f /im applext.exe

where applext is my external application.

then, when I want to close application I'm calling:

xShell = createUnoService("com.sun.star.system.SystemShellExecute")
xShell.execute("C:\path\stop.bat", "", 0, true)

For open the application I used two solution. One is :

xShell = createUnoService("com.sun.star.system.SystemShellExecute")
xShell.execute("C:\path\applic1.fcs", "", 0, true)

The second is:

Shell "C:\path\applext.exe"

As you can see, SHELL acts only on the .exe application, but xShell can acts direct on the file .fcs (in my case) created with the .exe application.

Now my little data logger can work alone and close and re-open the server application eatch time it detect that the comminication PLC to PC seems not to be good.

Maybe that can help you to close and re-open an external application. For me is working perfect.

Lazar
_________________
AOO3.4 User