Home
Sharing information with other applications
You can share files and graphics between HCL Notes® and other applications using a number of different techniques.
Advanced shared information topics
These tasks describe how to work with object linking and embedding, and how to import or export formatted data.
Object linking and embedding
Object Linking and Embedding (OLE) is a technology that lets you share data between applications and is supported for Microsoft™ Windows™.
Embedding data in a Notes document
You can embed data from another application into a rich-text field in an HCL Notes® document.
How can I edit an embedded object?

Sharing information with other applications
You can share files and graphics between HCL Notes® and other applications using a number of different techniques.
- Getting started with sharing information
  These tasks explain how to copy data into Notes, and how to share your Notes data with other applications.
- Sharing information with other applications quick reference
  This quick reference card is a list of instructions for common tasks and shortcuts for sharing information with other applications, which you can print and keep at your desk for easy reference.
- Working with shared information
  These tasks explain how to import and export data between Notes and other applications.
- Advanced shared information topics
  These tasks describe how to work with object linking and embedding, and how to import or export formatted data.
  - Object linking and embedding
    Object Linking and Embedding (OLE) is a technology that lets you share data between applications and is supported for Microsoft™ Windows™.
    - Embedding data in a Notes document
      You can embed data from another application into a rich-text field in an HCL Notes® document.
    - Creating links to other applications or data
      You can create links to data in other applications; to other HCL Notes® documents, views and applications; or to embedded objects by creating a linked OLE object in a rich-text field.
  - What is OLE 2.0?
    Put your short description here; used for first paragraph and abstract.
  - What is OCX?
    Put your short description here; used for first paragraph and abstract.
  - Troubleshooting tips for embedding OLE objects and ActiveX controls
    There are several reasons you may see the message: An error has occurred while processing a request on an object.
  - How can I export documents in a view into structured text files?
    Structured text is ASCII text. Exporting from an HCL Notes® view to structured text creates a file containing the text of the documents, minus any rich-text attributes, as well as all data in document fields.
  - How can I export view data into tabular text files?
    Tabular text is ASCII text arranged in rows and columns, separated by tabs. When you export a view to a tabular text file, each row in the HCL Notes® view becomes a text row (line). Each column in the view becomes a text column, separated by space characters. The contents of the Notes fields shown in the view become the entries in each column.
  - How can I export view data in CSV files?
    You can export HCL Notes® view data to a CSV file. The Comma Separated Value (CSV) file format is a simple ASCII text file with one record per line, whose fields are separated by commas. The documents in the view will appear as individual records in the CSV file.
  - How can I import structured text files?
    Structured text is ASCII text that is structured in fields that contain values. When importing structured text into a view, you must select an HCL Notes® form to accept the data.
  - How can I import tabular text files?
    Tabular text is ASCII text arranged in rows and columns, separated by tabs. When you import a tabular text file into a view, each text row becomes an individual document, and each text column becomes a field. The original table cell contents become field contents.
  - How can I modify an OLE object or ActiveX custom control using Notes® properties?
    With HCL Notes® properties, you can modify an embedded OLE object or ActiveX custom control to make it more useful to you. For example, by editing the Width property, you could widen an Excel spreadsheet to display more information on your screen.

How can I edit an embedded object?

About this task

You can edit an embedded OLE object's data by launching the original application from HCL Notes. If you're using Windows®, and the original application supports OLE 2.0, you can also edit in-place using the application's commands and toolbar directly in Notes.

How can I edit an embedded OLE object in the original application (out-of-place)?

Procedure

With the document in Edit mode, highlight the object (single-click).
Click Object Menu > Open.
Edit the data in the original application.
Click File > Exit & Return to Notes (or the application's command equivalent).
To save the new data in Notes, click File > Save.

How can I edit an embedded OLE object in Notes (in-place)?

You can edit in-place if the source application supports OLE2.

Procedure

With the document in Edit mode, double-click the object.
Edit the data. The Notes menu bar contains commands provided by the server application (as well as the Notes File commands). You can use the server application's commands and toolbar to edit the data directly in Notes.
Click anywhere in the document outside the object.
To save the new data in Notes,click File > Save.

Note: If an OLE2 object is very large (for example, a spreadsheet containing several hundred lines), it's best not to edit the object in-place. Instead, click the object and click Object Menu > Open. Then edit the object in the application's window.