Read data from ascii files using VBA
Read data from ascii files using VBA
(OP)
What should i do to read data from ascii files using VBA? I want to read the data and make a variable have the value i've read.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Read data from ascii files using VBA
|
RE: Read data from ascii files using VBA
'Read One Line at a time
Dim sVal As String
Open ("C:\YourFile.txt") For Input As #1
Do While Not EOF(1)
Line Input #1,sVal
MsgBox sVal
Loop
Close #1
'Read a delimited file (2 columns of data)
Dim sVal1 As String,sVal2 As String
Open ("C:\YourFile.txt") For Input As #1
Do While Not EOF(1)
Input #1,sVal1,sVal1
MsgBox sVal1 & vbCrLf & sVal2
Loop
Close #1
The latter method can use any variable type. If you could provide more detail about the file you are trying to read I can whip up a better sample.
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.