Have added a reference to Excel 8 to a project, which during execution loads data and creates an insistance of an Excel Worksheet

Two problems

1) When using the application generator asks for a reference to EXCEL8.OLB, (where do l find this).

2) When the operator uses the FILE->CLOSE option in excel he/she gets the window of death message, e.g Excel has performed an illegal operation. Otherwise Excel performs as expected.

Anyone got any solutions to these two problems?