Save all sheets as One Pdf

[desolatori]

Hello everyone,
I use office 2010 with the acrobat pdfmaker addon.
I would be grateful if you could help me with the following problem. I got the following code:

Please Login or Register  to view this content.

I have a workbook with multiple sheets(over 50) and I want to create One pdf containing all the sheets. I think the problem is the selection of the sheets, because with this loop only the last sheet is selected. I could also use an array of sheets eg

Please Login or Register  to view this content.

but I want a dynamic solution because the number of sheets is not the same all the time.
Is this possible?
Thank you for your help