in reply to Re^3: Open a file the way Ctrl+O works
in thread Open a file the way Ctrl+O works

I read the documentation for WIN::32::OLE... or rather, tried to read it. It contains a lot of terms that I don't get. WHat does it do, in a sentence? And how does it help what I need to do?

Replies are listed 'Best First'.
Re^5: Open a file the way Ctrl+O works
by gellyfish (Monsignor) on Aug 10, 2005 at 19:21 UTC

    OLE stands for "Object Linking and Embedding". It is now more commonly called COM (for Component Object Model) by MS developers. Essentially it is a mechanism by which an application (or a standalone library component) can expose some of its functionality through an object oriented interface. In the case of an application like Excel this means that you can automate much of the functionality of the application (Opening a workbook, reading and/or modifying cells, saving the workbook and so forth) from your own programs. The module Win32::OLE provides the ability to use OLE Automation from Perl programs.

    You can find a comprehensive discussion of the underpinning technology on MSDN

    /J\