Help with VBA code

[bgonzal1]

Hi new to this forum and new to VBA, I have a macro that exports data to a spreadsheet in a CSV file and sometimes the data exceeds 65k which for MSoffice2003 cannot exceed that count. I need to be able to have the data viewed in excel so I want to be able to do a funtion in VBA that can calculate the data and add a new tab when >65. I have a primary key column that gives my data a uniqueness for the count but i dont know the code in VBA to perform this task. Thanks for any help that can be provided.

[NTC]

hmmm - well there is something missing in your explanation. you say that you are exporting to excel - - - which means it is already in Access. In terms of records width limitation in general Access is more limiting than excel - - so it would seem that anything already in Access should export to excel ok.

I'm assuming you are discussiong record width as 65k record count isn't a problem for either product.

[bgonzal1]

not the case for excel 2003. Its limited to just above 65,000 when access can surpass the millions in data.

[bgonzal1]

and yes the data is alreading in access just the exporting in excel format with all needed data is the problem due to its size.