Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automation and Excel
Message
From
06/02/2003 09:42:32
 
 
To
06/02/2003 09:06:40
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00749786
Message ID:
00749834
Views:
21
>Thanks for the infor but it did not work. Any other suggestions?
>
>Curt

I went back to view exactly what I do. In stead of trying to remember.

LOCAL oleExcel && Excel Application
LOCAL oleWB && Workbook
LOCAL oleSheet && WorkSheet

*** Open the session
oleExcel = CREATEOBJECT( "Excel.Application" )
*** Add a workbook
oleWB = oleExcel.WorkBooks.Add
*** Select the sheet
oleSheet = oleWB.ActiveSheet

All My Code To Add The Data.

*** Close the workbook
oleWB.Close
*** Close Excel
oleExcel.Quit && Important!!

** Release all the referances from memory
RELEASE oleSheet && Sheet
RELEASE oleWB && WorkBook
RELEASE oleExcel && Excel

I'm afraid beyond that I can't help
Mike
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform