Printing specific worksheet of Excel file from Visual Basic program

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

Guest

Hi
Can somebody help me to print a specific worksheet of an Excel file thru Visual Basic

Thank
Davy
 
Davy:
Davy said:
Hi!
Can somebody help me to print a specific worksheet of an Excel file thru Visual Basic?

Thanks
Davy
Click to expand...

Try this:

Sub PrintSpecificSheet(ByVal i As Integer)
Sheets(i).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate _
:=True
End Sub

Where i is the Index of the sheet you want to print. you can overload this
to accept a String which could be the WorkSheet name, or you could just
change it to a string...

HTH,

Bill
 
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

Excel VBA - Problem with Closing Print Preview 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to find Visual Basic version of an exe file 4
Excel Borders not printing in Excel 8
how to read a matlab file with visual basic .net 2
'Cannot insert object' message when I try to put a button on a worksheet 7
Sorting an Excel worksheet using VB.net 2

Back
Top