Got about 50 workbooks that cannot be merged but need to make the data available in a nice easy way. Aany ideas how to open and close multiple workbook modally i.e control remains in some interface / menu window? all workbooks have multiple sheets and need to be opened read-only. thanks
It sounds like you just need to access the data from all your workbooks in one sheet.
You can use the following syntax to access the value of a cell in an arbitrary workbook/sheet.
Here's a link for more information.