And how would I make such a macro? Do you have some sample code?
john

<crferguson@gmail.com> schreef in bericht
news:1155932397.493531.17960@p79g2000cwp.googlegroups.com...
> Yes, that's possible.
>
> john wrote:
>> I haven't made any macro's in Excel but I was wondering if the following
>> is
>> possible.
>>
>> I would like to do the following:
>>
>> 1. Open Excel
>> 2. Run a macro that:
>> 3. Opens a particular file called c:\MyFile.xls, and
>> 4. Opens every Excelfile in a particular folder called C:\ToBeProcessed\
>> 5. For every Excelfile it should copy only the 2nd row (the 1st one with
>> data), and
>> 6. Paste the whole row after the last record of c:\MyFile.xls
>>
>> Thanks in advance for any help,
>> john
>