All
I use the code below to read a log file in notepad
Private Sub CommandButton12_Click()
'' Purpose : View the results of the log file
Dim viRetVal As Double
Dim vtFileLog As String
vtFileLog = ThisWorkbook.Path & Application.PathSeparator & "details.LOG"
If Dir(vtFileLog) = "" Then
MsgBox "No file available", vbOKOnly, "LogPrint" 'Can't find the file
Else
viRetVal = Shell("NOTEPAD.EXE" & " " & vtFileLog, 3)
End If
End Sub
What i would like to be able to do do is read the contents of the text file in a textbox on a userform with in excel, Is this easliy achievable?
Thanks for the help
Gibbo