Not knowing anything about your workbook or the current code you're
using, can you use the Workbook.SaveAs method and specify "xlCSV" as
the FileFormat parameter?

--JP

On Sep 21, 2:06*pm, Ken Warthen
wrote:
I have an Excel 2003 workbook in which users select a number of products,
enter pricing, margins, etc. *When the user is finished I need to create a
csv file with every permutations of their selections and entries. *I
originally was writing the records to a worksheet and then when finished I
would export the worksheet to a CSV file. *My code worked fine until it was
discovered that frequently the number of records could run into the hundreds
of thousands, exceeding Excel 2003's 65k limit.

I need to rewrite my code to write records directly to an external CSV file.
*If anyone has any experience in this area that they could share, I would be
very appreciative.

Ken