Write to an Excel file

Hello Folks,
 
I an trying to write to an Excel using Visual Basic 6. I have a form that I have created in VB; does not have functionality beyond displaying information. The trouble I am encountering is figuring out what would be my best approach. My idea would be to have either both a menu and toolbar option that the user would click to initiate this action. Once the action has been initiated the user will now see a window; kind of like what you would see if you were about to do a 'save as', the type of file should already be set and all the user has to do is simply enter a filename and specify a path. I see alot of examples showing how to open a Excel file through a VB program, but none showing how to save to one. Can anyone give me some clues/examples on how to tackle this? Thanks!

First, this is a VBScript forum, not a VB forum. Second, the section you posted in is for posting sample code not for asking questions. Third, searching this forum for "Excel Save" turns up a plethora of postings that detail how to save an excel sheet using VBScript which you should be able to use to point you in the right direction for a VB solution.