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