Error loading Reference file for MS Excel

[rboivin]

This post is a continuation of the post in the blogging section regarding the DataDriven test using Excel.

This is related to the Sample Excel Calc test which I loaded and had converted to VB.NET prior to including the reference to MS Excel.

I also created a new VB.NET solution and attempted to add the reference and I again received the same error.

Error loading code-completion information for Excel from Excel:
Could not find assembly file.

I do not get the error when adding the same reference within Visual Studio 2008.

I had removed all temp files and references which I thought may be the issue but nothing has corrected the error.

I'm running WinXP and Excel 2007

[Support Team]

Try to reference the Interop Excel library from the GAC as follows:

• Right click on "References" and choose "Add reference" in the project browser
• In the GAC tab add the Microsoft.Office.Interop.Excel by clicking on Select

Please write us your results.

Kind regards,
Gabor
Ranorex Support Team

[rboivin]

Error loading code-completion information for Excel from Excel:
Could not find assembly file.



------
I have the feeling it something simple but it only happens within Ranorex tool.

[Support Team]

Please install the "Primary Interop Assemblies for Office 2007":
http://www.microsoft.com/downloads/deta ... laylang=en

and reference the "Microsoft.Office.Interop.Excel" dll from GAC.

Please write us your results.

Kind regards,
Gabor
Ranorex Support Team

[rboivin]

The following are the messages I received:



Error loading code-completion information for Excel from Excel:
Could not find assembly file.

[Support Team]

We can't reproduce your bug.

Please send us your sample application to support(at)ranorex.com.

Kind regards,
Gabor
Ranorex Support Team