Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

rich text box in form

Status
Not open for further replies.

Timme1

Technical User
Oct 6, 2002
15
0
0
BE
Hi,

I have vb 6 and want to export data to ms excel xp in a
sheet that I made before, thus a template I made.
Then I want to view this sheet in a vb form.
Important is that the user of the program cannot see that excel is open at that moment. With a button in the form (with the ole excel link) I want a button to print the sheet.
Can anyone help me with this?

Tank you in advance,

Tim
 
One method would be to have a flexgrid control on your form and you can write that to an Exel sheet by using XLsheet as object - or you can read it from the XLsheet into the flexgrid control and print it from there. PK Odendaal
pko@942.co.za

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top