Posted by AcTiVision on December 12, 2001 8:14 AM
I have a 6 folder (all named differently); within those folders I have files (workbooks) that are also name differently; within each workbook there are 3 sheets, all name generically sheet1, sheet2...to sheet3. Now each workbook is password protected with a unique password. Here's the question. Is it possible to have excel grab a range of data from each workbook (from either sheet1, sheet2 or sheet3) and display them in a specified workbook? If so how would that be done, considering that each workbook is password protected with a different password for each workbook.
Thanks in advance,