Page 1 of 1

Error loading Reference file for MS Excel

Posted: Wed Apr 15, 2009 3:41 pm
by 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

Posted: Thu Apr 16, 2009 4:15 pm
by 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

Posted: Thu Apr 16, 2009 6:07 pm
by 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.

Posted: Fri Apr 17, 2009 1:09 pm
by 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

Posted: Fri Apr 17, 2009 8:24 pm
by rboivin
The following are the messages I received:



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

Posted: Wed Apr 22, 2009 12:11 pm
by 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