Programming Excel 2007 with VB 2005

I am have extreme dificulity with writing code in visual basic 2005 to
control excel. I have added references to the interop library but that seems
to only make available a small portion of the excel object model.

I believe the problem is that I am a total amautuer at vb 2005.

Are there any books to help with this? Interoperating w/ vb and excel?

I have read vb step by step, programming, laguage reference, and programming
ms office by whitechapel, but the do not provide the necessary information.
Whitechapel came close except he uses c#. I am unable to translate c# into VB
2005.

Do you know of any really good books? Books that explain classes,
namespaces, how to work with vb collections and excel collections, the
structure and ussage on the excel object model, ect.

I hope you can see where I am coming from. It may look like I havent a clue
and I guess I dont. I do understand programming but am not able to understand
the interoperation of the framework with ohter programs.

Help, please
.

Relevant Pages

  • Re: Question on a COM project.
    ... As for a book for working with COM interop in .NET, ... Excel or Word menu bar (after installation like PDF Write or Adobe ... The server side operation will be handled by calling a CGI file ... There is no ProgID as Adobe PDF or something indicating that the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to add or delete references programmatically
    ... That site is about Excel, ... Bear in mind that any programming of the VBE itself requires that Word ... I'm referring to the references shown by: ...
    (microsoft.public.word.vba.customization)
  • Re: Create DLL in Visual Studio 2005 accessible by Excel 2002
    ... and then register it for COM interop with regasm.exe. ... Excel 2002 to access it. ... to have access to my custom functions. ... Office XP Primary Interop Assemblies Known Issues ...
    (microsoft.public.dotnet.languages.vb)
  • Re: newbie question: c# and Excel
    ... > wraps the Interop calls. ... Just really didn't get the point of using VSTO. ... > I'd like to find a pure .NET way of generating Excel ... >>> could do in VBA? ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Create DLL in Visual Studio 2005 accessible by Excel 2002
    ... You see the reference in the Excel Macro box, ... Started Visual Studio 2005 and started a New Visual C# Class Library ... I believe I need to use COM interop to allow VBA ... to have access to my custom functions. ...
    (microsoft.public.dotnet.languages.vb)