Here is the Assignment:(OLE) A macro is required which puts zeros into all the columns other than the Teams column of the Excel spreadsheet table(spreadsheet is attached).A VB program is required to input a match result and update the table. It should have a command button Update Table and text box controls for the home team, goals scored by the home team, away team and goals scored by the away team. The Update Table command button, when clicked, should update all columns (including goals scored and conceded) of the Excel spreadsheet table using OLE automation objects and display the Excel table of the teams in alphabetical order in an OLE control.
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Deadline information
I have to hand in this assisnment by 3/12/01