Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP and Excel...
Message
De
04/03/2002 05:52:52
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
03/03/2002 18:11:49
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00626165
Message ID:
00627691
Vues:
14
>>>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform