The only way that I can think of doing this would need a Windows system with Microsoft Office and Perl installed. In that scenario, you should be able to use Win32::OLE to be able to control Excel and Word via the OLE API.
The Win32::OLE module does have an OLE browser that you can use to try to figure out details about OLE objects (methods and properties). Personally, I've only gotten the browser code to work with using ActiveState's ActivePerl. Since the copyright of the module is owned by ActiveState, that might be the reason why.
The general technique for figuring out how to use Win32::OLE to automate office applications is to records a macros that does the desired task and then port that VB code into Perl code. In your situation, the task involves two different office applications, which could make this technique a bit more tricky to do. But I personally would probably still try this technique to see if it would help out.
|