SUMMARY

Receiving these errors when trying to run Excel Spreadsheet example with Microsoft Office 2000.

DETAILS/CAUSE

Microsoft Office 2000 does not provide wrapper assemblies for its libraries.

RESOLUTION

Visual Studio has a tool "TlbImp.exe" that can be run to create an assembly in a specified library.

Open an MS-DOS command Window.

Change directory to:

C:\Documents and Settings\<username signed in with>\My documents\ASNA examples\AVR for .NET 8.1\WINDOWS\Excelspreadsheet\Excelspreadsheet\Bin\Debug

 Then enter this command:

 "C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\TlbImp.exe" Excel9.olb Excel.dll

That will create the Excel.dll in the project folder that will then act as a reference and will fix the Excel errors.

After the Excel.dll is successfullycreated, 4 lines of code will need to be changed by adding "Excel." These are the lines:

Now the Excel.dll will need to be refereneced in the project.

Right click References in the Solution Explorer and select Add Reference

In the Select Component window, select eh Browse tab and browse to the Excel.dll that was created in the Debug folder of the project. Click Add then Ok.

.

Recompile the project.