MS Excel

I wrote a simple program in Visual Basic 6 for student information. I used MS Access Database for storing the data.

I want to use MS Excel for reports. How can I create and control reports in MS Excel from button(s) on Visual Basic form? Could any one help?

Have a look at Garrett's Office reporting example here (http://www.visualbasicforum.com/showthread.php?threadid=16520), or try a search of the forums. I believe you will come up with a number of relevant examples.