Excel 2007 takes forever to export Data

I have a macro that is used to export data to a ~ delimited file. The macro runs fine with Excel 2003. However when we try to use it in an excel 2007 file it takes forever to export the data. I.E. in excel 2003, I can export 65k rows of data in just 6 minutes. However it took 53 minutes to export 45k rows in excel 2007. I would appreciate any help with solving this issue. The macro code is below:

Please Login or Register  to view this content.

Hi

Although not much consolation I have found the same thing happening, with macros running much slower than in previous versions, around 10 times slower on average.

I have not been able to find any way to speed things up.

Regards

Jeff

Well I think it has something to do with the way it is calculating the number of columns.

I tried the following to see how many rows/columns it was counting

Please Login or Register  to view this content.

It returns a total of 16384 columns even thoul I am only using 15.

I tried to use

Please Login or Register  to view this content.

to count the columns but it errored.

If this is the case, how can I tell it only to use the used columns (15 in my case) without hard coding 15?