• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Using Access with Microsoft Excel > Using Excel as an OLE Server

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint