"Chip Pearson" wrote ...

You can't just write to Excel files using VBA's file write
procedures. Excel files are internally extremely complicated, and
VBA doesn't support the data types required to manipulate them
directly. You should use Excel itself to modify Excel files.

Another option is to use the Microsoft OLDB Provider for Jet i.e. ADO
and SQL to write data to an Excel file. Using SQL's INSERT INTO syntax
will append the new row to the bottom of the Excel range.

Jamie.

--