Thread: Looping through excel files to add to a new workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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 With QuoteReply With Quote