Print multiple worksheets - each worksheet to a separate pdf

[ronaldelias]

Hi there.

I am using Excel 2007. I have a work book with 200 worksheets and want to print each of the worksheets as a separate pdf. I do have the full version of acrobat.
Is this possible without going into each worksheet separately and clicking print?

While I'm at it here's another question. All 200 of the worksheets have a different number of rows. There are 2 heading rows at the top of each sheet, and then anywhere from 2-40 rows following those that include 3 columns of numbers (currency) I need sums for all of them. I've already done it all with the autosum function, but had to do it on 200 separate worksheets. It would be easy if all of the worksheets had the same number of rows, but they don't. Any ideas or suggestions?

Thanks

Ron

[maniacb]

These solutions are attainable, but it would help us to help you if you could share an example workbook, as per the yellow banner above. Maybe you can share a workbook with 3 sheets?

[ronaldelias]

Thanks.

I attached a small file to the original post.

Ron

[ronaldelias]

I have found this VBA code that theoretically does exactly what I want, but i get a file error 11 and division by 0 error. Any ideas?


Sub SaveAsPDF()
Dim CurWorksheet As Worksheet
For Each CurWorksheet In ActiveWorkbook.Worksheets
CurWorksheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=Application.ActiveWorkbook.Path & “\” & CurWorksheet.Name, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Next CurWorksheet
End Sub

[maniacb]

Try

Please Login or Register  to view this content.

Still working on the sum of each page

[ronaldelias]

That works beautifully. Thank you VERY much!

Ron

[maniacb]

To add the sum

Please Login or Register  to view this content.