Macro that adds records
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
|