Displaying an excel file in vb6 form

[varadaradj]

Hi

Earlier I've generated reports to Text Files only in VB6. I can display the contents of the Text File in a RichTextBox control in a form in VB6, where the user can preview the file or they can give printing through a command button which was placed in the form.

But, now I'm generating reports using Excel Only. Is it possible to display an excel file generated through reports module by me. My intention is only to display the Excel file in a VB6 form where the user can scroll through the excel file (can't be modified) and/or they can print the excel.



Alternatively, I can save the excel file to PDF file finally after generating report. Now I want to display the PDF file in a vb6 form through which the user can view and/or can print the same.

Can anybody please help me how can I display a Excel or PDF file in a vb6 form. To do so, what controls (ActiveX) I need?

[Missinglinq]

...My intention is only to display the Excel file in a VB6 form...

...how can I display a Excel or PDF file in a vb6 form...

I'm guessing that, despite a dozen or more members reading your post, you've received no responses is that you appear to be asking a question about Visual Basic 6...rather than about Access.

We may have members who are versed in VB6...but your question probably belongs in a Visual Basic forum.

Linq ;0)>