Spreadsheet-ParseExcel - Picking up cell values from incorrect worksheet

Posted on Mon Feb 12 22:42:46 2007 by tommyindigo
Picking up cell values from incorrect worksheet
I am using Spreadsheet-ParseExcel, and it works well normally...however I am using it now with a rather complex Excel workbook that contains many macros and graphics. I can get the value for the correct cell, however it comes from the wrong worksheet. I played around with the target cells/worksheets. It usually the corresponding cell, but is 2 or 3 tabs away! If I use the EXACT SAME code to target a "dummy", simpler workbook I created, it works fine. Is there any workaround known for using ParseExcel with a complex workbook? Unfortunately, I don't have the flexibility of changing the source workbooks.
Direct Responses: 5663 | Write a response