Very Computer

Hello,

I'm a foxpro 2.6-user/programmer and I have the following problem.

A foxpro-program generates a Excel-worksheet. At the end of the program
Excel has to start with the data the program just generated.

I know I have to do this with DDE like
  mchannum  = DDEInitiate("excel", "system")
    ...
    ...
but don't know it exactly.

If MS Excel (Office97) isn't already started, Excel have to start up.
Also Excel must start up with a alternate (already designed) xlt-file, so my
output is being formatting well.

Please help me!!!

Thanks a lot....
Oswald.

Hello Oswald,
please refer first to the DDESetOption() in the help file.This FN determins
wether you'll be asked to start EXcel if it isn't running yet.
Further there is another possibility to start EXcel with the RUN/n EXcel.exe
mySheet. This will only work if EXcel and the Sheet are in the MSDOS Path.
In addition there is a sample in the FPW\sample\-folder.
--

mfg

Wolfgang Schmale / Germany

Quote:>Hello,

>I'm a foxpro 2.6-user/programmer and I have the following problem.

>A foxpro-program generates a Excel-worksheet. At the end of the program
>Excel has to start with the data the program just generated.

>I know I have to do this with DDE like
>  mchannum  = DDEInitiate("excel", "system")
>    ...
>    ...
>but don't know it exactly.

>If MS Excel (Office97) isn't already started, Excel have to start up.
>Also Excel must start up with a alternate (already designed) xlt-file, so
my
>output is being formatting well.

>Please help me!!!

>Thanks a lot....
>Oswald.

Hi Oswald,

If you're using Win95 or higher you could try:

run /n2 start myspreadsheet.xls

HTH,

Renato