| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through excel files to add to a new workbook
Hi I need to loop through a series of excel files stored in a folder on my C
drive, add data to the spreadsheet, select the modified data range (number of rows differs from spreadsheet to spreadsheet) and sequentially enter this data into a new spreadsheet to be imported into an Access table. Can anyone out there help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping through excel files to add to a new workbook
Start here
http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Geoff" wrote in message ... Hi I need to loop through a series of excel files stored in a folder on my C drive, add data to the spreadsheet, select the modified data range (number of rows differs from spreadsheet to spreadsheet) and sequentially enter this data into a new spreadsheet to be imported into an Access table. Can anyone out there help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looping a column in workbook 1 to workbook 2's sheets | Excel Programming | |||
| Looping through files in a folder | Excel Programming | |||
| Looping thru files extracting data | Excel Programming | |||
| Looping thru files | Excel Programming | |||
| looping to create multiple files | Excel Programming | |||
Hybrid Mode
