VB5 nd Excel 97

[jritchie]

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?

[Lloyd]

Hi there,

For the reference question it should be at Project --> References on the VB menu bar. In that list there should be something like Microsoft Excel 8.0 Object Library.

As for the second question try to reboot and if that don't work then try to uninstall Excel and then reinstall it. If that don't work then there maybe something interfering with it somewhere (I found that FindFast screws things up alot.).

I hope this helps,
Lloyd

[jritchie]

Thanks Lloyd,

Already had the reference to Excel8. The interesting thing is we don't get the problem on the development machine in either interprative or compiled mode, but get it on three test PCs