Print an Excel file in VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have a previously created an Excel file and want to print on default printer.

Want to initiate printing from within my application.

Thanks
 
Hi Gavin-

1) Add a reference to Excel Object Library in .NET
2) Include (with Imports statments)
Imports Excel = Microsoft.Office.Interop.Excel 'Reference: Excel Object
Library" 3) Add (with Class member variable statements)
Friend WithEvents exWB As Excel.Workbook
Friend WithEvents exAPP As Excel.Application
Friend WithEvents exWS As Excel.Worksheet
4) Open the excel file (using OpenFileDialog)
exAPP.Workbooks.Open(ofd.FileName)
5) Use the PrintOut method for object you want to print.
exApp.ActiveSheet.PrintOut

John
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Epson XP-3150 not printing 2
Excel VBA - Problem with Closing Print Preview 0
Problem printing red coloured fonts in Excel 1
How can we convert OST to PDF file format? 1
HP1320 Printing too light 4
Print layout in rdlc report 0
Printing to various network printers... 4
Laserjet 6L print density adjustment 0

Back
Top