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?