I've copied and pasted this macro for a few other excel files. It basically exports the specified sheet as a csv file, and strips out any blank lines. Works great in all my other excel macro enabled files...only in this application its exporting the rows horizontally...so I end up with all rows being converted to one really long single row file. Very odd.
Thing is it works fine for all other files, and if I copy paste it into this particular sheet I get the export happening as one big row.
The code looks all good and I'm not sure how its happening. Can we insert anything into the code to prevent this from happening?
I would attach the sheet but most no-one wants to touch a macro enabled worksheet...
Thanks!
Bookmarks