Print Excel Report in VB 1

[misssaraliz]

What is the code to print an Excel spreadsheet in VB? I've only seen code on how to print reports within Access.

I already have code set up that exports and saves the Access report to Excel format. My trouble is with the printing of the Excel spreadsheet.

Thanks so much!

 

[jbrite]

This is an example of how I print an Excel Worksheet through VB.
Hope this will help. Good luck...


xlPrice.Worksheets("Sheet1&quot.PageSetup.PrintArea = ("$" & Area & "$1:$" & SecArea & "$40&quot 'Page Print Area
xlPrice.Worksheets("Sheet1&quot.PageSetup.PrintGridlines = True
With xlPrice.Worksheets("Sheet1&quot.PageSetup
.Zoom = False
.FitToPagesTall = 1
.FitToPagesWide = 1
.LeftMargin = Application.InchesToPoints(0.7)
.RightMargin = Application.InchesToPoints(0.7)
.TopMargin = Application.InchesToPoints(1.1)
.BottomMargin = Application.InchesToPoints(1.1)
End With
xlPrice.ActiveSheet.PrintOut

jbrite