http://qs321.pair.com?node_id=227202


in reply to Using Win32::OLE and Excel - Tips and Tricks

Great "tutorial" on Excel with Win32::OLE! I am trying to extract data from one Excel file, and input that data into another Excel file. The problem comes when trying to have two open Excel files, and make the data transfer happen in the same block. I was thinking of creating a subroutine for each function -- one for extracting the data and sticking it in an array, and one for inputing the data from the array into the other spreadsheet ... However, before I go through the effort, I thought I'd ask the Pro's! Any good guidance or experience in this or a similar Excel problems? Thanks ...