The article Calling Excel 2007 Custom Wizards from the Office Fluent Ribbon by Using VBA (http://msdn2.microsoft.com/en-us/library/bb927654.aspx) demonstrates how to create a custom wizard in  Excel 2007 using VBA and then modify the Ribbon to call the wizard.

Albert Raiani does a great job in explaining how to trigger custom code when you drag data from an external source onto a Excel 2007 worksheet in his newly released article Adding Drag-and-Drop Functionality using the .NET Framework and Visual Studio 2005 Tools for Office Second Edition (http://msdn2.microsoft.com/en-us/library/bb840032.aspx). Lots of examples also.

Also, take a look at the six-part Office Talk columns titled Bringing Improvements to the Excel 2007 Table (Part 1 through 6) (http://msdn2.microsoft.com/en-us/library/bb693324(office.11).aspx) on enhancements to data tables in Excel 2007 and how working with tables is much easier than in previous versions.

Enjoy!