Export to CSV with Macro...but getting 1,000,000+ lines

[unclejemima]

I've got a macro that was generously created by a user on this forum. I've been using it in another sheet, and ported it to a new one I'm using.

Basically I want to export a specific tab, but as the file can have 5 rows or 5000 (max 10,000) I want it to clear any blank lines so when I import the file into our POS it won't try and import a bunch of blank lines.

Anyhow, with this formula now I'm getting an error opening the file (what has 8 rows I think) that it exceeds the 1 million lines error. Can anyone view the code and see if its possible to mod it better to remove all blank lines?

Thanks!

Please Login or Register  to view this content.

[unclejemima]

Ok. I the problem was in my sheet. Not with the code. I had changed some "if" statements so that they would return "" instead of 0. That cleared up the millions of blank rows.

Now I'm getting still one blank row at the bottom. Its not visible as such when your looking at it...only when I go to import it into our POS application it will come in as a blank line. This is something with the code I'm certain.

I can edit the csv, simple delete the row under the last one with values, save over top of it and re-import and it won't bring in a blank line.

What would be the best way to fix this? Can someone add the code to remove one line minus the count with values...or clean up the above code to actually remove all blank lines?

Thanks :-)

[Marc L]

Hi !

Just try this mod : Print #1, txt;

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

[unclejemima]

OOooh. Thats good! How does that work? Was the code incorrect?

[Marc L]

No, I just add the part you forgot to tell to the generous original author …

Thanks for the rep' !