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!

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

Controlling Print Preview of MS-Excel from VB

Status
Not open for further replies.
vprasadblr

vprasadblr

Technical User
Sep 7, 2001
1
IN
Hi All,
I have a situation.
I am writing some data from VB to Excel. I want to use the Excel Print Preview control for the user to print the Excel sheet.
After printing, if the user clicks on the 'Close' button of the Print Preview screen, I want the application to close the Excel file, quit from Excel & return back to the VB application.
I want use the Excel for printing because a report is to be printed. Since Excel allows easy formatting of reports, I thought it would be wise to use Excel & also print from Excel itself.
Can anyone of you help me ?
 
Status
Not open for further replies.

Similar threads

sal21
  • Question
via vb 6.0, please split access table
Replies
1
Views
170
strongm
strongm
sal21
  • Locked
  • Question
get controll type, controll name from the second panel of SStab 1
Replies
4
Views
684
strongm
strongm
sal21
  • Locked
  • Question
FORMAT output of Debug.Print .responseText (from api rest)
Replies
4
Views
463
2009luca
2009luca
Ken01
  • Locked
  • Question
Extraction of Picture box point / pixel colors. 3
Replies
13
Views
2K
klima
K
2009luca
  • Locked
  • Question
CHECK color of shape 2
Replies
5
Views
401
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top