Error loading Reference file for MS Excel

Ranorex Spy, Recorder, and Studio.
rboivin
Posts: 11
Joined: Tue Apr 07, 2009 7:14 pm

Error loading Reference file for MS Excel

Post by rboivin » Wed Apr 15, 2009 3:41 pm

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

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Post by Support Team » Thu Apr 16, 2009 4:15 pm

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
Posts: 11
Joined: Tue Apr 07, 2009 7:14 pm

Post by rboivin » Thu Apr 16, 2009 6:07 pm

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.

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Post by Support Team » Fri Apr 17, 2009 1:09 pm

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
Posts: 11
Joined: Tue Apr 07, 2009 7:14 pm

Post by rboivin » Fri Apr 17, 2009 8:24 pm

The following are the messages I received:



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

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Post by Support Team » Wed Apr 22, 2009 12:11 pm

We can't reproduce your bug.

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

Kind regards,
Gabor
Ranorex Support Team