>>>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
Ric,
Last parameter is how indow would be showed. Here you set it to 0-'hide'.
#define SW_HIDE 0
#define SW_SHOWNORMAL 1
#define SW_NORMAL 1
#define SW_SHOWMINIMIZED 2
#define SW_SHOWMAXIMIZED 3
#define SW_MAXIMIZE 3
#define SW_SHOWNOACTIVATE 4
#define SW_SHOW 5
#define SW_MINIMIZE 6
#define SW_SHOWMINNOACTIVE 7
#define SW_SHOWNA 8
#define SW_RESTORE 9
#define SW_SHOWDEFAULT 10
#define SW_FORCEMINIMIZE 11
#define SW_MAX 11
Set it to something else ie: 1.
Cetin