Using Excel as an OLE Server
This section describes methods of creating links between data cells in OLE Object fields and worksheets created with Excel 97. You can duplicate some examples with Excel 3.0 and 4.0, but version 5 and later versions—with their OLE 2+ compatibility—have several added features that simplify the process. The step-by-step examples in this section are based on the assumption that you are familiar with the use of Excel 5+.
You can embed or link an Excel worksheet or graph as a bound or unbound OLE object. You can copy data from the OLE worksheet object to the Clipboard and then paste the data into a bound or unbound text box. The following sections provide examples of these techniques.
Embedding an Excel Worksheet in a ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
