Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Collecting data from different workbooks into summary workbook
Hi there
I've got trouble collecting datas for different workbooks into a main sumamry workbook. The WB are all saved onto a spesific folder on a server, but the summary WB only collects the data when all workbooks are opened in excel. How can i get the summary WB to collect data from other WB's without opening them all? Thank you in advance for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Collecting data from different workbooks into summary workbook
Hi,
There are methods you can use on closed workbooks but using a macro it's simple to open each workbook in turn and manipulate the data. The 2 subs below open each workbokk in a folder in turn. The first opens the workbook and then calls the second where you can work on your data. Sub OpenFiles() Dim FSO As Object Dim Folder As Object Dim File As Object Set FSO = CreateObject("Scripting.FileSystemObject") Set Folder = FSO.GetFolder("c:\") ' Change to suit For Each File In Folder.Files If File.Type = "Microsoft Excel Worksheet" Then Workbooks.Open Filename:=Folder.Path & "\" & File.Name 'Call your macro and do things Call dothings ActiveWorkbook.Close True End If Next End Sub Sub dothings() MsgBox ActiveWorkbook.Name End Sub Mike "Espen Rostad" wrote: Hi there I've got trouble collecting datas for different workbooks into a main sumamry workbook. The WB are all saved onto a spesific folder on a server, but the summary WB only collects the data when all workbooks are opened in excel. How can i get the summary WB to collect data from other WB's without opening them all? Thank you in advance for your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Collecting data from different workbooks into summary workbook
Hi Mike, thank you for the effort
I am afraid your solution wont work for me since source WBs could be opened by others. I guess the easiest way to solve this would be to put it all in one WB, but I would like different departments to be able to register data independent off each others. Can this be done? Mike H skrev: |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Collecting data from different workbooks into summary workbook
Hi Mike, thank you for the effort
I am afraid your solution wont work for me since source WBs could be opened by others. I guess the easiest way to solve this would be to put it all in one WB, but I would like different departments to be able to register data independent off each others. Can this be done? Mike H skrev: |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Collecting data from different workbooks into summary workbook
See Ron de Bruin's site for collecting from closed workbooks.
http://www.rondebruin.nl/copy7.htm Or this page at Ron's site. http://www.rondebruin.nl/ado.htm Gord Dibben MS Excel MVP On Mon, 25 May 2009 03:07:02 -0700, Espen Rostad wrote: Hi Mike, thank you for the effort I am afraid your solution wont work for me since source WBs could be opened by others. I guess the easiest way to solve this would be to put it all in one WB, but I would like different departments to be able to register data independent off each others. Can this be done? Mike H skrev: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I merge and link workbooks into one summary workbook? | Excel Worksheet Functions | |||
summary of data from several workbooks in another | Excel Discussion (Misc queries) | |||
Creating multiple workbooks from summary workbook | Excel Discussion (Misc queries) | |||
Multiple Workbook Data Capture Summary Sheet | Excel Discussion (Misc queries) | |||
Workbook Summary Data from Sheets | Excel Worksheet Functions |