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?– DaveParilloDec 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.– mindless.pandaMar 16, 2010 at 14:57
Add a comment
|
2 Answers
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.
=[workbookname.xlsx]sheetname!$D$10
Here's a link for more information.
-
+1 That definitely does sound like a more logical approach than opening 50 workbooks.– nhinkleSep 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.
