| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Data from Multiple Closed Workbooks to Open Workbook
Is there a way programmatically that I can copy data from multiple
workbooks and append each set of data to an open work book. Here is the situation I have about 35 large workbooks each containing data for a market I need to combine all the data so do analysis throughout all 35 instead of having to search 1 by 1 and then adding up the data manually. Any ideas or help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Data from Multiple Closed Workbooks to Open Workbook
Ron de Bruin has code here that can get you started...
"Create a summary worksheet from different workbooks" http://www.rondebruin.nl/summary2.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Kris" wrote in message Is there a way programmatically that I can copy data from multiple workbooks and append each set of data to an open work book. Here is the situation I have about 35 large workbooks each containing data for a market I need to combine all the data so do analysis throughout all 35 instead of having to search 1 by 1 and then adding up the data manually. Any ideas or help would be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Data from Multiple Closed Workbooks to Open Workbook
Or maybe ?
http://www.rondebruin.nl/ado.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jim Cone" wrote in message ... Ron de Bruin has code here that can get you started... "Create a summary worksheet from different workbooks" http://www.rondebruin.nl/summary2.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Kris" wrote in message Is there a way programmatically that I can copy data from multiple workbooks and append each set of data to an open work book. Here is the situation I have about 35 large workbooks each containing data for a market I need to combine all the data so do analysis throughout all 35 instead of having to search 1 by 1 and then adding up the data manually. Any ideas or help would be greatly appreciated. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Data from Multiple Closed Workbooks to Open Workbook
These look great. Thanks for the help I am going to look into using
them first thing tomorrow. Thank you, Kris On Oct 31, 11:16 am, "Ron de Bruin" wrote: Or maybe ?http://www.rondebruin.nl/ado.htm -- Regards Ron de Bruinhttp://www.rondebruin.nl "Jim Cone" wrote in .. . Ron de Bruin has code here that can get you started... "Create a summary worksheet from different workbooks" http://www.rondebruin.nl/summary2.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Kris" wrote in message Is there a way programmatically that I can copy data from multiple workbooks and append each set of data to an open work book. Here is the situation I have about 35 large workbooks each containing data for a market I need to combine all the data so do analysis throughout all 35 instead of having to search 1 by 1 and then adding up the data manually. Any ideas or help would be greatly appreciated.- Hide quoted text -- Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| hi, i am trying to copy data to closed workbook | Excel Programming | |||
| Importing data from multiple closed workbooks | Excel Programming | |||
| Copy data from a closed workbook (ADO) | Excel Programming | |||
| copy data from a closed workbook | Excel Programming | |||
Linear Mode
