Having to resave a csv file after running a macro

[grecianite]

Hi all,

First post, so I really appreciate any help you guys can give.

I've written a macro, that from one sheet, it makes three csv files and it broadly works fine.

The three csv files it creates are around 250kb and if you look in notepad, you can see line upon line of commars (where there is no data), if I resave as a csv, the file become 1kb and the commars disappear.

I was just wondering what Excel does to clean the file up and why when it is initially saved, the file is not in a clean state?

My code is shown below!


Thanks,

John

Please Login or Register  to view this content.

[grecianite]

I should add, that the three files created will always have different names, so I cannot build another macro to reference the newly created files (as the name will be different.

[grecianite]

I know this is not good form and not good etiquette, but just bumping this to the top again!

Thanks and sorry!!

[Cutter]

@ grecianite

Welcome to the forum. Bumping is quite alright (within reason - once per day) but:

Please notice that [CODE] tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.