Re^2: Open a file the way Ctrl+O works

Replies are listed 'Best First'.
Re^3: Open a file the way Ctrl+O works by gellyfish (Monsignor) on Aug 10, 2005 at 18:09 UTC
I guess you are going to want to use Win32::OLE - you can find hundreds of articles here on the subject. /J\	[reply]
Re^4: Open a file the way Ctrl+O works by eyidearie (Novice) on Aug 10, 2005 at 19:05 UTC
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?	[reply]
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\	[reply]