How can i export excel data into text file

[mukka]

Hi Techs,
i had four excel sheets filled with data,i need to read respective rows concatinating and finally put as a single row in a text file.
Pls help
-Chak

 

[Store300]

Its worth having a look at the Print & Write help files in VBA

 

[ratman]

If you need some help with the excel row values you need to find and concatenate let me know.....but if not just do all that and save it as a text file......just replace my bullshit path and filename below with your path and file name.



Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="\\LOUISE\PRODCONT\My Excel Files\Quote\RFQMASTER-RFQMASTER.txt", FileFormat:=xlText, CreateBackup:=False

Workbooks("RFQMASTER-RFQMASTER.txt&quot.Close