Books on Visual Basic .NET for Excel ONLY.. Please help

[krayziez]

Hey,

I do alot of macros for Excel and have been pretty good at it, but I can only do it with the record macros command under Excel. I tend to copy and paste lines of codes to make it do other basic things so I know I'm a complete newbie when it comes to coding.

I want to find out a way to learn basic programming JUST FOR EXCEL. I don't want to go too hardcore with it either. I've tried to buy books on it but never really had the time to learn everything. I just want to specialize in Excel's macro programming and need a good reference to learn. Most books on amazon deal with All of VB. I just want an easy book on just Excel part of VB... I know I won't have the motivation to go through programming stuff that doesn't relate to what I want to learn exactly--EXCEL only... Any suggestions would be greatly appreciated!

[Edneeis]

Then you should look into books that are specific to VBA (Visual Basic for Applications) that is the language that the macros are in. There is no .NET version of that yet. There are some work arounds using the Visual Studio.NET Tools for Office or you can connect to the Excel COM objects in .NET but this is not the same as the macros. So just find a book on VBA or VBA for Excel or just read a lot of the help files and google the rest. VBA is not even full VB so a VB book isn't really what you need either.

[krayziez]

Great thanks for the info! I'll see what I come up with.