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.
Maybe the simplest to use is a good program launcher.
The article Best Free Program Launcher lists many free launchers (see also the comments).
After a quick look at some screenshots, maybe your best bet is 8start Launcher, but as I said this was after taking a (too?) quick look.