Running Batch Files....

[stlrain95]

is there a way to run a batch file from a FOXPRO form??

I have several code pieces to run word, excel, etc. But I am not quite sure if I can run a batch file?

Any help is appreciated!!

Thanks,

 

[DSummZZZ]

You can use RUN or !:

! C:\SomeDir\MyBatch.BAT

Dave S.

 

[stlrain95]

Thanks, I think.

I put the code in there and it starts to run the batch file, then just stops. When I run the batch file on it's own it works great??

Any other suggestions?

 

[ramani]

HI
Number of ways to do what you want.
1. Create buttons for each item and ADD CODE in its click event ..
oE=createobject("excel.application&quot
oE.visible = .t.

oW=createobject("word.application&quot
oW.visible = .t.

2. You can use ShellExecute..

DECLARE INTEGER ShellExecute IN shell32.dll ;
INTEGER hndWin, STRING cAction, STRING cFileName, ;
STRING cParams, STRING cDir, INTEGER nShowWin

You can put this code anywhere in your application, provided it is executed before you start using this code.
(Note ShellExecute is case-sensitive in the above command.)

ShellExecute() lets you "execute" any pogram, document or shortcut. At its simplest, it can be used to launch an external application. For example, this command will launch Notepad:

ShellExecute(0,"open","Notepad.Exe","","",1)

Alternatively, you could use the following code to launch Notepad and have it open a file called Readme.txt:
ShellExecute(0,"open","Readme.txt","","",1)

The following will open Word with a new file...
ShellExecute(0,"open","WinWOrd.exe","","",1)

The following will open Excel with a new file...
ShellExecute(0,"open","Excel.exe","","",1)

SO in the buttons click event , you can put the code..
DECLARE INTEGER ShellExecute IN shell32.dll ;
INTEGER hndWin, STRING cAction, STRING cFileName, ;
STRING cParams, STRING cDir, INTEGER nShowWin
ShellExecute(0,"open","Excel.exe","","",1)

Hope this helps you ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[DSummZZZ]

Could be a PATH problem, or a Bad command or file name problem, or.....
You'll probably have to be the one to determine the failure of the batch file.

Dave S.

 

[stlrain95]

Gentlemen,
The ShellExecute() worked wonderfully!!

Thank you guys for the help!!