Thanks, Dave. I believe I got this part down. Still have problems with the
..open code, though.

"Dave Patrick" wrote:

"How do I know that it will write the recordset on the correct sheet? I know
B8 specifies the range."

Good question and you can (also good practice) specify the sheet as in;

Sheets("sheet1").Range("B8").Offset(0, Col).Value =
Recordset.Fields(Col).Name

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect