O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required