Reading values from a txt file

[ajpalm]

I'm using VBa in excel, and wondering if there is a way to read a txt file values in.

eg

I wish to read the 2nd line of a file, and store its value as a varabile within the vba project?

Any ideas?

 

[JustinEzequiel]

dim sFile as string
dim sLine as string
dim sSecondLineFromFile as string
dim nFile as integer

nFile=freefile

open sFile for input as nFile
line input #nFile, sLine ' reads first line
line input #nFile, sLine ' reads second line
close nFile

sSecondLineFromFile=sLine