Export excel sheet as text file with macro code

Question

Hi,

How do I export a specific excel sheet (say sheet1) as a text file? I would like to do this with macro code.

Grateful for ideas on this.

\Jonas 

Answer 1

This code will do it:

Sheet1.SaveAs "C:\output path\output file.txt", <format>

The <format> parameter is of type XlFileFormat; for a CSV text file, use xlCSV or xlCSVMSDOS.  The VBA documentation enumerates all the possible format options.

Answer 2

Thanks a lot, it works like a sharm!