If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Appending excel worksheets | Rbuzard | Worksheet Functions | 3 | September 13th, 2005 11:57 AM |
Adding multiple worksheets | Craig | Worksheet Functions | 1 | July 6th, 2005 07:21 PM |
Worksheets are referenced in expressions, how make the worksheets visible? Excel 2000 | L Mehl | General Discussion | 2 | July 27th, 2004 07:20 PM |
Internal Link treated as an unfound external link | Henri Martin | Links and Linking | 4 | March 10th, 2004 08:02 PM |
Removing external links in Excel | Tom Carnahan | Links and Linking | 1 | February 23rd, 2004 09:26 AM |