good books for Mastering MS Excel
Can anyonyone recommend me any good
Books by John Walkenbach are excellent (though I haven't looked at his Office 2003 books yet). Here is one on Formulas and one on VBA:
Macros are really just embedded functions in the spreadsheet. If you need a function to do something that isn't provided by the built-in functions you can use a macro.
Sorry, hate to be nitpicky, but macros most definitely are not "just embedded functions". Macros (VBA) allow you almost unlimited customization. You could even write an entire GUI program in Excel using VBA in which the user never even sees a spreadsheet. I would assume that you would need two separate books - one on macros and one on functions, since they are so different.
Incidentally, if we're talking Excel 2003, the Visual Studio Tools for Office allow you to write .Net code against the Excel object model.
Er, can't you do that with just about any version of Office provided you enable the proper reference?
I have done it using C# from Visual Studio .NET 1.0.
Thanks Jordan that is a great link.
Fog Creek Home