1. Please read: http://www.cs.pitt.edu/~chang/156/06oracle/myexample.html
http://www.cs.pitt.edu/~chang/156/06oracle/getname.html
http://www.cs.pitt.edu/~chang/156/06oracle/retreive.html
These documents are enough for you to do the exercise using Excel and Oracle.
2. The following Module is STRICTLY REQUIRED:
Sub Auto_Open()
UserForm1.Show
End Sub
If your program works well, this module should bring the interface out
as you open the file (*.xls).
3. Table Name and Field Name are STRICTLY
REQUIRED to be exactly the following: STUDENT, NAME,
SSN, MOD, COMPLETE_DATE, GRADE (some of them
should be needed in the program),
because your program would be tested on the database that I give. I are not
responsible for modifying your code to match my STUDENT table.
4: You are NOT
allowed to modify these two sentences:
Set OraSession =
CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.OpenDatabase("beq-local.world", "scott/tiger", 0&)
5. When you close
your file or EXCEL, maybe you would run into this problem:
The Macros in This
Project Are Disabled
Solution to this
problem: