| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to access data from closed workbooks
Hi,
I am looking for a VBA code that will do the following: I have several files within one workbook (maybe fifty) that I would like to summarize all the data into another master workbook. Each file has data in the "summary" tab in cells A1 thru A76. I would the macro to extract the data into one worksheet column A,B,C etc. Can it automatically extract data from all files in a certain folder? thanks for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA to access data from closed workbooks
hi,
look the example at the following link Copy a range from closed workbooks (ADO) http://www.rondebruin.nl/win/s3/win024.htm isabelle |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA to access data from closed workbooks
On Friday, March 27, 2015 at 2:28:51 AM UTC-4, isabelle wrote:
hi, look the example at the following link Copy a range from closed workbooks (ADO) http://www.rondebruin.nl/win/s3/win024.htm isabelle I might be able to get this working for me, thanks so much for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Data from Closed Workbooks | Excel Worksheet Functions | |||
| SAVING DATA TO CLOSED WORKBOOKS | Excel Worksheet Functions | |||
| Access Closed workbooks (2003) | Excel Worksheet Functions | |||
| How to access ranges in closed workbooks in custom functions | Excel Programming | |||
| get data from closed workbooks! | Excel Programming | |||
Hybrid Mode
