Hi,

I have a macro that creates 2 csv files from an excel file, these files are generally about 249k in size due to the number of blank cells with commars between.

If I then resave the file as csv again for a second time (using the same file name) Excel somehow cleans the file up so it's only 1kb in size.

Does anyone know why Excel does not clean the file up in the first instance, because it's a bit annoying having to resave files manually!

Thanks,

John