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.

Hi Tom

I will update the add-in soon and will check this out
Send me one of the workbooks private if you want so I can test it.


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.

If you want to copy the sheet test from each workbook to a new workbook you can try
this if I understand you correct.
http://www.rondebruin.nl/fso.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tomas C" wrote in message ...
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.

Hi Tom

I update the add-in and fixed your problem I think (I not get your workbook to test)

Try the new version
http://www.rondebruin.nl/merge.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Hi Tom

I will update the add-in soon and will check this out
Send me one of the workbooks private if you want so I can test it.


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.

If you want to copy the sheet test from each workbook to a new workbook you can try
this if I understand you correct.
http://www.rondebruin.nl/fso.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tomas C" wrote in message ...
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.