¡@

¡@

' DATA ENTRY OR READ DATA FROM FILE

'

' PROGRAM DEVELOPED BY ENYA CHANG

' COPYRIGHT 2001   CHEER

'

Sub DataEntry(Xpos, Ypos)

      Dim Entry As String

      Dim X(100) As Single, Y(100) As Single, N As Integer

      Cls

'

'       DATA ENTRY MODE SELECTION

    Entry = InputBox("Data Entry From File <Y/N> ", "SELECT ENTRY MODE", "Y", Xpos, Ypos)

        If Entry = "Y" Then

        Call DataEntryFromFile(N, X, Y, Xpos, Ypos)

    Else

        Call DataKeyIn(N, X, Y, Xpos, Ypos)

    End If

'  CHEER 2001

End Sub

 

 

Sub DataKeyIn(N, X, Y, Xpos, Ypos)

      N = 0

      Do

            N = N + 1

            Do

              Debug.Print "X,Y OF THE #", N, " POINT";

              X(N) = Val(InputBox("Enter X value of the point", "X", , Xpos, Ypos))

              Debug.Print "  X ="; X(N);

              Y(N) = Val(InputBox("Enter Y value of the point", "Y", , Xpos, Ypos))

              Debug.Print "  Y ="; Y(N)

              YN$ = InputBox("Are the data input correct?", "YesNo", "Y", Xpos, Ypos)

            Loop While YN$ <> "Y" And YN$ <> "y"

            YN$ = InputBox("Input Next Data?", "YesNo", "Y", Xpos, Ypos)

      Loop While YN$ = "Y" Or YN$ = "y"

      Cls

      YN$ = InputBox("Save Data to File?", "YesNo", "Y", Xpos, Ypos)

      If YN$ = "Y" Or YN$ = "y" Then

            Call SaveDataToFile(N, X, Y, Xpos, Ypos)

      End If

End Sub

 

 

Sub SaveDataToFile(N, X, Y, Xpos, Ypos)

Dim FileNo As Long, FileName As String

    FileNo = FreeFile

    FileName = InputBox("Enter File Name ", "FILE NAME", "DataEntry.dat", Xpos, Ypos)

    Open FileName For Output As #FileNo

        Print " I", " X(I)", " Y(I)"

        For I = 1 To N

            Print #FileNo, X(I), Y(I)

            Print I, X(I), Y(I)

        Next I

    Close #FileNo

End Sub

 

 

Sub DataEntryFromFile(N, X, Y, Xpos, Ypos)

Dim FileNo As Long, FileName As String

FileNo = FreeFile

FileName = InputBox("Enter File Name for Data Input", "FILE NAME", "DataEntry.dat", Xpos, Ypos)

 

Open FileName For Input As #FileNo

    N = 0

    Print " I", " X(I)", " Y(I)"

    Do While Not EOF(FileNo)

        N = N + 1

        Input #FileNo, X(N), Y(N)

        Print N, X(N), Y(N)

    Loop

Close #FileNo

End Sub