Exporting a worksheet

[DesignerX]

When I export a worksheet to a text file, the entire sheet is exported (even the blank rows) which makes the file quite large considering the small amount of information the sheet stored.

How can I export only the first x rows to a text file ?

thx.

[drecollet]

Not sure if this would work, but you could try setting the print area. Go to File, then "Print Area" then Set Print Area.

[DesignerX]

Nope, didn't work.

There must be a way to do this. It is very inefficient otherwise.

anyone ?

thx.

[VBA Noob]

Maybe this link will help

http://www.meadinkent.co.uk/XLexport-text1.htm

VBA Noob