Programming Excel 2007 with VB 2005

[David Bell]

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

 

[Karl E. Peterson]

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.

I believe the problem is you're using a language that wasn't designed for this task.

Why not use one that was -- VBA or even ClassicVB?