Sharing Information Between Programs
Excel can convert data or text from one format to another using a technology known as object linking and embedding (OLE). OLE allows you to move text or data between programs in much the same way as you move them within a program. The familiar cut and paste or drag and drop methods work between programs and documents just as they do within a document. In addition, Excel and all Office programs have special ways to move information from one program to another, including importing, exporting, embedding, linking, and hyperlinking.
Importing and Exporting
Importing and exporting information are two sides of the same coin. Importing copies a file created with the same or another program into your open file. The ...
Get Excel® 2013 On Demand 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.
