>>Hi everyone... now I have done some research on this but do not quite have the answer I am looking for from FAQ and other threads....
>>
>>I have a user pulling some data in a very cut down version of my app (VFP 6.0). Once the data is pulled, and put into an excel spreadsheet, the user then wants to open excel and play around... but, CLOSE the calling VFP app as well... so, what is the best way to do this without leaving any dangling objects, etc...??
>>
>>TIA
>>
>>Ric
>
>Ric,
>You could createobject() do whatever you want, set excel to visible and quit VFP.
>However if you don't need an object ref. to work within excel before making it visible I'd choose ShellExecute() launching excel and quit.
>Cetin
Cetin,
I am using the SheelExecute but all I am getting is a 'blink' and then nothing happens... I am using the example from the WINAPI area as follows?
DECLARE INTEGER ShellExecute IN "Shell32.dll" ;
INTEGER hwnd, ;
STRING lpVerb, ;
STRING lpFile, ;
STRING lpParameters, ;
STRING lpDirectory, ;
LONG nShowCmd
=Shellexecute(0,"Open","c:\my documents\lisa\lisaspec001.xls","","",0)
So, could you help and tell me what I am missing here??
TIA
Ric