Using excel microsoft office interop excel ошибка

1

Answers

• Hi JJJMonty,

  Actually, if you want to use this DLL, following these steps:

  1.       On the Project menu, click Add Reference.

  2.       On the COM tab, locate Microsoft Excel Object Library, and then click Select. In Visual Studio 2005, locate Microsoft Excel 11.0 Object Library on the COM tab.

  3.       Click OK in the Add References dialog box to accept your selections. If you are prompted to generate wrappers for the libraries that you selected, click “Yes”.

  Then you should be able to use this interop DLL, for more details, please visit Primary Interop Assemblies.

  Hope this helps!

  Thanks!

Answers

• I had this problem and it resolved after I ran the Office 2003 repair. Use Add Remove programs> Go to the tab Change or remove programs
  Go to Microsoft Office Professional 2003. Click the link «Click here for support information». Use Repair Button.

  This works.

  • Proposed as answer by

    Tuesday, March 2, 2010 2:08 AM

  • Marked as answer by
    Martin_XieModerator
    Friday, October 22, 2010 4:44 AM

• Phil Marino,

  Based on your post, I created a new WindowsApplication1 in VB 2005 Express Edition. I copied a sample.xls, added reference of Excel Object Library 12.0 (I am using Office 2007) then use your code snippet with a Button and ListBox control. The application runs well when clicked debugging.

  I publish the application with the default location: http://localhost/WindowsApplication1/, then I can see the page that to install the project and run. The application runs well, too. I can see the result in the ListBox after clicking the button.

  I would like to suggest you to download the OleView.exe to see the related information on RegKeys, Typelib to track down the cause of your problem.

  Hope that can help you.

• hi again…

  Im gonna answer myself hehe…

  I changed this in the code and now works in all the computer =)

  Dim oExcel As Excel.ApplicationClass —-> Dim oExcel As Excel.Application
  

  
  Dim oBooks As Excel.Workbooks

  Dim oBook As Excel.WorkbookClass ——> Dim oBook As Excel.Workbook

  D

  im oSheet As Excel.Worksheet

  • Proposed as answer by
    surendra singh samant
    Thursday, August 27, 2009 4:13 AM
  • Marked as answer by
    Martin_XieModerator
    Friday, October 22, 2010 4:43 AM

• friends this is Balaji.

  i felt reliable to share the issue i solved. inface the one i face nd suffered from 2-3 days. this is for absolute beginners. Might the Big-B’s knw. but for a beginner newly coding involved with processes would find it help full.

  this error :-

  unable to cast com object of type ‘Microsoft.office.Interop.Excel.ApplicationClass’ to interface type ‘Microsoft.office.Interop.Excel._Application’ .

  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

  if this arise — the one i solved is not exactly solution in all situations.  a case of mistake can be made by a beginner.

  the situation i solved :

  I tried to kill all the EXCEL processes as some times i used to get the excel file is being used by another processes.

  Solution :

  by doing that we are killing almost the connectivity to the excel. because we import excel in vb.net that process — even that process gets killed nd so the interop classes functionality stops working as the classes connectivity to excel is broken.

  that means by any means if the excel process is terminated we wil get that error.

  • Proposed as answer by
    balajivalla
    Tuesday, September 7, 2010 7:33 AM
  • Marked as answer by
    Martin_XieModerator
    Friday, October 22, 2010 4:44 AM