Hii ,
I request you , to give some information that , how to save a work sheet as text file in VB 6.0
regards,
Printable View
Hii ,
I request you , to give some information that , how to save a work sheet as text file in VB 6.0
regards,
Hi Twinkle
See if this helps...
Code:'~~> 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