Article ID: 142193 - View products that this article applies to.
This article was previously published under Q142193
OLE Automation provides a way for Visual FoxPro for Windows to interact with other OLE-compliant applications. Using OLE, the Visual FoxPro program can start a Microsoft Excel session, open a workbook, select a worksheet from the workbook, place data into a cell or range of cells, print a worksheet, save the updated workbook, and close the Microsoft Excel session. This article shows by example how to do just that.
Examine the Microsoft Excel Help topic "Application Object" and the many topics that are introduced in the Properties and Methods lists of that topic.
For more information about many of the concepts in the example program, please see the following articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/139051/EN-US/ )How To Select Cells in Microsoft Excel by Using OLE Automation
(http://support.microsoft.com/kb/132535/EN-US/ )PRB: Releasing Object Variable Does Not Close Microsoft Excel
(http://support.microsoft.com/kb/138398/EN-US/ )PRB: Release may not Remove OLE Objects from Memory
Article ID: 142193 - Last Review: July 13, 2004 - Revision: 3.3
Contact us for more help
Connect with Answer Desk for expert help.