I get empty new lines in my textfile output

**grid** · 12-28-2010, 06:20 PM

Hello,
I use my script to export a range of values to a textfile. No big deal. Along the way I get empty new lines in the output file. I don't want to see empty new lines. Can anyone help me to export te results without empty new lines between values? For me this code works faster than any of CPearson because it won't interrupt Excel. http://www.cpearson.com/excel/ImpText.aspx

Please Login or Register  to view this content.

I hope I am clear enough so far.
Thanks in advance,
grid

**jaslake** · 12-28-2010, 09:39 PM

Hi grid

Try this

Please Login or Register  to view this content.

Let me know of issues.

John

**Marcol** · 12-28-2010, 09:44 PM

Seems to me at least, you are not defining, nor assigning, a value to "Path" in Sub WriteIt.

So where do we go from here?

**jaslake** · 12-28-2010, 11:15 PM

Hi grid

Or simply change your existing code to

Please Login or Register  to view this content.

John

**grid** · 12-29-2010, 06:10 AM

John, yeah thats nice. Thank you!
Marcol, how would you customize path? Can you give an example code?
Thanks in advance,
grid

**Marcol** · 12-29-2010, 07:35 AM

Looking at your original code I don't think you need to define Path as a variable

Try this

Please Login or Register  to view this content.

Hope this helps

**grid** · 12-29-2010, 08:30 AM

Marcol, thank you! I only made a few adjustments in this code of the original.
Greet,
grid

I get empty new lines in my textfile output

LinkBack

Thread Tools

Rate This Thread

Display

I get empty new lines in my textfile output

Re: I get empty new lines in my textfile output

Re: I get empty new lines in my textfile output

Re: I get empty new lines in my textfile output

Re: I get empty new lines in my textfile output

Re: I get empty new lines in my textfile output

Re: I get empty new lines in my textfile output

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions