View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SMS - John Howard SMS - John Howard is offline
external usenet poster
 
Posts: 16
Default Excel v10. Extra lines printing to Text file

In using excel's Print #Num, ThisLine.
'ThisLine' is produced in VBA by concatenating each cell in a specified row.

I am getting all the data into Notepad perfectly spaced and formatted.

Trouble is I am getting an extra blank row below each line of data also.

These are having to be manually deleted prior to a batch main frame upload.

How do I suppress the extra lines.?

TIA

John Howard
Sydney, Australia