Excel 2007: combining multiple print files

[elephantspants]

Hi

I have a report spreadsheet that uses lookups.

There is a print control sheet. This sets parameters used in the reports and defines the sheets to print e.g.:

Pack Parameter 1 Parameter 2 Start End
Dashboards Population 2 Variable 1 8 8
Dashboards Population 2 Variable 2 11 11
Dashboards Total Variable 3 13 15

Some VB cycles through the rows, selects the sheets (spec'd by start and end) and currently outputs to PDF.

So, in the example above, there are 3 PDFs.

What I really want is to combine the PDFs into one (I only have Adobe Reader 9). Alternatively append to one printfile. Is there any way to do this that doesnt involve installing any software/addins?

Thanks for any help

 

[SkipVought]

hi,

Some VB cycles through the rows, selects the sheets (spec'd by start and end) and currently outputs to PDF.

1) output X to PDS files
2) output X to printer

???

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[elephantspants]

Sorry - I dont understand the question.

Ideally I'd like a PDF - but if the only option to combine them is in a printfile then I'd take it.

 

[SkipVought]

What does it matter if you print the PDF or print the WORKSHEET that the PDF was generated from???

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]