His website is absolutely worth bookmarking if you're going to do much in Excel. He has a lot more to say about the topic.

If it can be done manually, it can be automated with an XLA Add-In.' Microsoft Excel 2007 Advanced Premier Training Limited 4 Ravey Street London EC2A 4QP Telephone +44 (0)20 7729 1811 Advanced Excel 2007. Tutorial VBA dan Macro Dasar dengan Excel 2007 Visual Basic for Application atau VBA adalah sebuah bahasa pemrograman yang dibuat oleh Microsoft dan dapat digunakan untuk meningkatkan kemampuan aplikasi Office, termasuk di dalamnya Excel. Indeed, an Add-In can be written to do nearly anything you want. An Add-In can also provide tools to manipulate the data in a workbook. An Add-In may contain User Defined Functions (UDFs, see Writing Your Own Functions In VBA) that provide calculation functions specific to your own area of interest or business, functions that extend beyond the normal calculation capability of Excel. 'An XLA Add-In is a certain type of workbook that provides custom functions and/or tools that extend the basic functionality of Excel. Here's a great resource I use all the time: Excel workshops and seminars available to individuals and teams.

I would guess something similar would work for you. Excel at everyday functions, spreadsheets, formulas, PivotTables, macros, graphs and more.

I placed this in a mapped network drive and Excel connects to it each time it opens. Hi there, Im feeling some dificulty in using the 2003 macros that are created in Excel 2003 in the new Excel 2007. I'm not sure if this is a 'best practice' or not, but I created an Excel add-in (.xla file type) that has all of my custom formulas (creatively named 'CustomFunctions.xla).

Microsoft excel 2007 tutorial macros