Reply to thread

Message: [QUOTE="Steve Yandl, post: 6257301"] Unless you need notepad open for some other reason besides extracting line 7 as a text string, you don't need to use it. If OpenFile is the full path and file name of the text file you're checking, try something like: ____________________________________ Const ForReading = 1 Set oFSO = CreateObject("Scripting.FileSystemObject") Set oTxtFile = oFSO.OpenTextFile(OpenFile, ForReading) For x = 1 To 6 oTxtFile.ReadLine Next strLine = oTxtFile.ReadLine oTxtFile.Close _____________________________________ Now, strLine is the text from line 7 and you can check it for the date value and you didn't need Notepad to be launched at all. Steve [/QUOTE]