It happens that F formulated :
I save a .xlsx file holding results from a data logger each day. The files
are all saved into the same folder.

I have a workbook (Excel 2010) which holds the accumulating data from rows 10
to 206 in columns A and C in each of these files and which interprets it.

Rather than have to open the new data logger file each day, manually copy the
relevant columns and rows and then paste them into the workbook below the
previously imported data, I would prefer the task to be automated. Is this
possible in full, or at least partially?

TIA

Most data logger software (Like MadgeTech, for example) will generate
other data output file types like CSV, TXT, DAT, or XML (for pocket
PCs, etc) that you should be able to use standard VB file I/O
procedures to read the data and 'dump' it into any worksheet at any row
you specify. (I currently do this for filtering out non-relavent
readings lines based on client criteria for what range[s] of data they
want to analyze)

Alternatively, you can use ADODB (if you don't want to open every
source file[s]) to read the data into a recordset and 'dump' that data
into your worksheet.

With either approach, you don't have to physically open any source
files. With ADODB you don't even need to open the target workbook to
update the data because you can use its UPDATE function to add new
data.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc