Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel won't paint correctly
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00716458
Message ID:
00716846
Views:
10
David,
Well in that case:
release oExcel
VFP can release it's reference before you close Excel (i think:). I looked at my source, and noticed that the spread sheet was opened in print preview mode:
oExcel.Visible=.t.
oExcel.ActiveWorkBook.PrintPreview() && PRINT PREVIEW SHOW
release oExcel
The task dialog shows NO excel

>Terry,
>
>This process is creating the XLS file from scratch, it's not opening an existing file.
>
>>I use this to open an Excel sheet after a reference in created:
>>
   oExcel.WorkBooks.WorkSheet.Open(oXLSFile)
>>   oExcel.Visible=.t.
>>   release oExcel
Imagination is more important than knowledge
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform