Use the FileSystemObject

Excel Help for Use The Filesystemobject in Automating Data Analysis Tasks

Use The Filesystemobject

Rate this: (3/5 from 1 vote)

	You can read in text files within Excel by using the FileSystemObject in VBA code: VBA Code: Sub Read_text_File() Dim oFSO As New FileSystemObject Dim oFS Set oFS = oFSO.OpenTextFile(”c:\textfile.TXT”) Do Until oFS.AtEndOfStream sText = oFS.ReadLine 'Do here what you need to do with the line of information Loop End Sub
	Excel Business Forums Administrator
	Posted by Excel Helper on 02 Feb 2009

View Full Post