Read up on the Excel object in VB. This is pretty straightforward stuff, and you will probably find some examples in the Sandbox. You need to create an Excel object in memory and you can then populate it by looping through
NotesDatabase.Views and so forth.
--
http://www.benpoole.com