Removing blank lines in report

[Gazzr]

Hi,

I have a report that produces a text file. When I open it in Word its
about 3,000 pages long. This is because 60% of the report is blank
lines.

Is there a way to take out the blank lines using VBA? Once the file is
reduced I hope to import it into Excel.

Regards
Garry

 

[Greg Maxey]

Gazzr,

There are more direct ways to perform your specific task, but my Clean Up
Text Addin may prove helpful.

http://gregmaxey.mvps.org/Clean_Up_Text.htm