PIA references for Office.

Hot Topic

Creating application on existing code
SQL Express Local and Remote database
Application.Run vs Form.Show vs Form.ShowDialog
MIcrosoft Visual C++ Runtime Library
Where to declare variables?
Me.Invoke How to use it with sub routines?
Charts?
Windows service application in Visual C# Express
Win32 Console Application template linker error
No Debug?

VS Express Editions

Creating a dll in C and then using it in Visual C# express
MSI Installer and C# Express
SQL Express refuses to install
incompatible types - from 'char [4]' to 'LPCWSTR'
Adding a second form
visual c++ express
License and time limit
How to disable the column sorting in DataGridView?
Random Letters
How do i get Data Out of a List Box and Seperate it ?

PIA references for Office.

Hello.

I have Office 2003, VB 2005 Express running on XP Home

I am trying to interfaces to Excel using some code from another forum. My problem fails on the first line of the code.

Imports Microsoft.Office.Interop

The IDE complains that the Namespace or type is missing. I have included the references to "Microsoft Office 11.0 Object Library".

I have tried to install the required PIA by selecting the required option from the Office install but still I get errors. I have tried to use the PIA distribution pack, but that seemed to fail halfway through the install process.

I am really stuck now - how can i sort this out .

Any help greatly appreciated.

Thanks,

Richard




Answer this question

PIA references for Office.

  • Frédéric Feytons

    Hi Richard,

    I don't think Office.Interop is a valid namespace. Try adding a reference to the Excel 11.0 Object Library instead and then use:

    Imports Microsoft.Vbe.Interop

    You should then be able to interface with Excel.

    Hope this helps,

    Steve Hoag

    Visual Basic Express



  • Roman-Alifanov

    Thanks Steve, I will give that a go...

    Richard


  • PIA references for Office.
Answer this question