How to save a worksheet as text file

[twinkle99]

Hii ,

I request you , to give some information that , how to save a work sheet as text file in VB 6.0

regards,

[Siddharth Rout]

Hi Twinkle

See if this helps...

'~~> FILE FORMATS
Const xlText = 20           '<~~ Use this for Text (Tab Delimited)
Const xlCSV = 6             '<~~ Use this for CSV Comma Delimited
Const xlTextPrinter = 36    '<~~ Use this for Formatted Text (Space Delimited)

'~~> I am using the 1st File format. Change as applicable
'~~> oXlBook is your workbook object
oXlbook.SaveAs Filename:="C:\Book1.txt", FileFormat:=xlText, CreateBackup:=False