Hi Dave, below is the attached code
Private Sub Form_Load()
Readtextfile ' Call Function to Read the text files and Display the messages
Form1.Visible = False
End Sub
Function Readtextfile()
Dim fsoAny
Dim txtfilemessage
Dim txtfilecounter
Dim txtfilehtml
Dim sRecordmessage As String
Dim sRecordcounter As String
Dim Path1 As String
Dim Path2 As String
Dim htmltext
Path1 = "C:\Techfol\Messagefile.txt"
Path2 = "C:\Techfol\Counterfile.txt"
Path3 = "C:\Techfol\message.htm"
Const ForReading = 1, ForWriting = 2, ForAppending = 3
i = 0
Do While i <> 1 ' Putting in a infinite Loop
htmltext = ""
htmltext = "<table><tr><td><img src =insideGElogo_37.gif></td><td><img src =eef.gif></td><td><b><font face=Arial size=4 color=#C0C0C0>- EEF Technical Services</font></b></td></tr></table><p><p><p>"
Set fsoAny = CreateObject("Scripting.FileSystemObject")
Set txtfilemessage = fsoAny.OpenTextFile(Path1, ForReading, False)
Set txtfilecounter = fsoAny.OpenTextFile(Path2, ForReading, False)
If Not txtfilemessage.AtEndOfStream Then
sRecordmessage = txtfilemessage.ReadLine()
Else
sRecordmessage = ""
End If
If Not txtfilecounter.AtEndOfStream Then
sRecordcounter = txtfilecounter.ReadLine()
Else
sRecordcounter = ""
End If
If sRecordmessage <> sRecordcounter Then
txtfilecounter.Close
Set txtfilecounter = fsoAny.OpenTextFile(Path2, ForWriting, False)
txtfilecounter.WriteLine (sRecordmessage)
Set txtfilehtml = fsoAny.OpenTextFile(Path3, ForWriting, False)
htmltext = htmltext & "<marquee>" & sRecordmessage & "</marquee>"
txtfilehtml.WriteLine (htmltext)
txtfilehtml.Close
test = Shell("""C:\Program Files\Internet Explorer\iexplore.exe""c:\techfol\message.htm", 5)
End If
txtfilemessage.Close
txtfilecounter.Close
sSleep (10000)
Loop
End Function