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

  • Do they all have the same structure? Are you trying to summarize / find data within them? Dec 3, 2009 at 0:22
  • What do you mean they can't be merged? Why not run a script to merge them into a separate read-write workbook? Why would you want to open 50 workbooks all at once - that doesn't seem nice and easy. Give us more info. If it were me I would merge 50 workbooks into one workbook, one worksheet per workbook. Mar 16, 2010 at 14:57

2 Answers 2


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.

  • +1 That definitely does sound like a more logical approach than opening 50 workbooks.
    – nhinkle
    Sep 3, 2010 at 3:46

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .