I am using Ron de Bruin's excellent RDBMerge Add-in, but I am running
into a problem. I have about 100 Excel workbooks that contain two sheets
that are named identically throughout the workbooks. One of those sheets
is a chart, the other is a data sheet that contains three columns of
information. However, preceding those data are 16 rows of header info
that I don't need.

I use the add in and specify the sheet name and that I want the copying
to begin at A16. Everything seems to work except that instead of copying
data from A16 to the end of the sheet, it copies from A1 to A16 every
time. If I open the workbook, activate the data worksheet, save and
close, the add in works as it should.

So, am I doing something incorrectly? Is there a way to activate a
worksheet named "TEST" in each workbook within a directory, save it, and
close it programatically? Thanks in advance for any help.

Tom

PS Many thanks to Ron for providing all the information that he does on
the web.