Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel error
Message
From
24/08/2000 17:23:30
 
 
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:
00409019
Views:
22
>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.

Argh, hit Send and then realized I'd used "worksheet" throughout my message and it should have been "workbook". Here's the answer again, but right this time:

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 oWorkbook. Then, you can use the Workbook's Application property to get a reference to Excel:

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

Now you have variables to reference both the workbook 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