Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and Excel...
Message
From
03/03/2002 18:11:49
 
 
To
28/02/2002 07:37:57
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00626165
Message ID:
00627629
Views:
10
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform