Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel error
Message
From
24/08/2000 17:21:13
 
 
To
24/08/2000 14:50:03
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexico
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00408726
Message ID:
00409016
Views:
24
>mmm... sounds interesting, how can i refers the Excel application using the GetObject() call?. Because one of the lacks of using createobject("excel.application") is that the objects remains in memory no matters the vfp variable has been released.

Sorry, I should have answered that in my original message. First, I recommend that rather than calling the variable you get back from GetObject oExcel (or oXL or whatever), you call it oWorksheet. Then, you can use the Worksheet's Application property to get a reference to Excel:

oWorksheet = GetObject("yourfile.XLS")
oExcel = oWorksheet.Application

Now you have variables to reference both the worksheet and the application. Just be sure to set both to .null. once you shut down Excel.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform