Appending external worksheets into existing workbook?

Hi,

I was wondering - I need to iterate through a set of identically
formatted workbooks (values will be different in key cells of course).

For each workbook, I need to extract 2 worksheets that I will place
into my consolidation workbook. The workbook code will extract the data
required based on a worksheet that I have created (so the worksheets
that are imported must have the same tab names to ensure that my
formulae work). results are stored in a final worksheet - 1 row per
import. On the next import, the two worksheets will be deleted and
replaced by a fresh new set. Hope this makes sense.

The problem is, I have no idea how to perofrm the open/copy-append part
of the code. I am an Access developer by trade, so VB is not the issue.
It's the Excel way of working that I am having to learn the hard way!


If anyone can help me, I would ve very grateful indeed!

Many thanks.


--
Xuratoth

Not sure I follow the scenario.
How about recording your actions when doing it manually, using the
macro recorder.
If there are then issues you need to address you can post the code and
ask about the specific issues.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup