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
Bookmarks