up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this question
0% accept rate
Do they all have the same structure? Are you trying to summarize / find data within them? – DaveParillo Dec 3 '09 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.panda Mar 16 '10 at 14:57
feedback

2 Answers

up vote 1 down vote

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.

link|improve this answer
+1 That definitely does sound like a more logical approach than opening 50 workbooks. – nhinkle♦ Sep 3 '10 at 3:46
feedback
up vote 0 down vote

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.