Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To summaryze information from many workbooks without open it
Hello,
In a server, I have about 300 workbooks in a server. All the workbooks are indentical and have sheet named " SUMMARY". Without bothering people who maybe using it, how can I get the information of each worksheet from the cell range: Range("C7,C8,E7,D118,H5,D63,E63,D70,F70," & _ "D80,F80,D102,F102,D108,D109") and summaryize it in a workbook without opening each workbook. Should we use ADO or DAO to do it?, Please help. For your information if we open the workbook manuallly it prompts us to kein the password, which is a window password, say "TopSecret", all the same password for each workbook. Thanks in advance, Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when i open an Excell file 3 workbooks open.Why? | Excel Discussion (Misc queries) | |||
Information from Closed workbooks | Excel Discussion (Misc queries) | |||
When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
Sharing Information Between Workbooks | Excel Worksheet Functions | |||
Looking up information in 2 different workbooks | Excel Discussion (Misc queries) |