We have a .dat file that contains tabs & spaces as delimiters. We need to edit this file to replace a particular field in a record. One way I thought is to import the file to excel and edit code using VBA. Though I succeeded editing the column with new value, I'm stuck with exporting the excel back to .dat file with preserving the format. Is there a way to edit .dat file directly?

You can read a .dat file like you would any other TextFile.

Dim sr as StreamReader
Dim sFile as String
sr = File.OpenText("file.dat")
sFile = sr.ReadToEnd()
sr.Close()

hth.


================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Use the following to save in txt format (dat)

Sub Save_File()

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs Filename:="c:\test\testfile.dat", FileFormat:=xlTextMSDOS

Application.DisplayAlerts = True

End Sub


http://www.vbadud.blogspot.com