Login or sign up Lost password?
Login or sign up
Get Open Filename("Text Files (*.txt),*.txt, Log Files (*.log),*.log, All Files (*.*),*.*", Title:="Select Alarm Log File (ZEOH/ZEOL)", Multi Select:=True) For Each logfile In File Name For I = 1 To Len(logfile) If Mid(logfile, I, 1) = "\" Then y = I Next I t = Mid(logfile, y 1, Len(logfile) - y 1) Active Sheet. Find(What:="*", Search Direction:=xl Previous, Search Order:=xl By Rows). Value = Mid(strline, 68, 11) 'Time Start End If If Mid(strline, 61, 1) = "-" Then Cells(totalrows, 2).