Hi.

I need to print the same sheet about 600 times (with different values) to
ONE PDF.
Im thinking of printing the sheet and append the result to an existing PDF.

Is this possible? How can i do this?

Thanks a lot SpeeD

you could use primo pdf, but i'm not sure you could do it without interacting
with the program,

--


Gary Keramidas
Excel 2003


"SpeeD" wrote in message
...
Hi.

I need to print the same sheet about 600 times (with different values) to
ONE PDF.
Im thinking of printing the sheet and append the result to an existing PDF.

Is this possible? How can i do this?

Thanks a lot SpeeD

Hi Gary

I use Acrobat distiller...

SpeeD

"Gary Keramidas" wrote:

you could use primo pdf, but i'm not sure you could do it without interacting
with the program,

--


Gary Keramidas
Excel 2003


"SpeeD" wrote in message
...
Hi.

I need to print the same sheet about 600 times (with different values) to
ONE PDF.
Im thinking of printing the sheet and append the result to an existing PDF.

Is this possible? How can i do this?

Thanks a lot SpeeD

.

If the data on your sheet is roughly "page size", meaning it all fits nicely
on one PDF page, then here is the first thought that popped into my head. It
will require some VBA to make it work.

For each of the 600 or so different values you will have to use, plug the
value into your main sheet. Copy the results to a second sheet, starting at
row 1. Then with the next value plugged in, copy the results from the main
sheet directly below the first results on the second sheet. Continue doing
this until you exhaust your loop (600 times). I'm guessing this will all fit
on one sheet, even in Excel 2003, because 600 * 80 (lines on one page?) =
48,000 rows required.

Once you have all 600 sets of data on a single sheet, you can set the
horizontal page breaks (again using VBA) to separate the sets of data into
individual pages. Once that's done, you can print just that sheet to a PDF
file, and you'll magically have your 600 pages of data! Then you just delete
that temporary sheet if you no longer need it. You could also add a table of
contents, title page, etc, at the beginning of the temporary sheet if desired.

"The VBA coding is left to the student as an exercise"

HTH,

Eric

"SpeeD" wrote:

Hi.

I need to print the same sheet about 600 times (with different values) to
ONE PDF.
Im thinking of printing the sheet and append the result to an existing PDF.

Is this possible? How can i do this?

Thanks a lot SpeeD

Eric.

It´s not an orthodox solution but it will surely work... but to be honest i
would prefer to print 1 by 1 and append it to the end of the PDF...

Thank´s a lot Eric!!

Speed



"EricG" wrote:

If the data on your sheet is roughly "page size", meaning it all fits nicely
on one PDF page, then here is the first thought that popped into my head. It
will require some VBA to make it work.

For each of the 600 or so different values you will have to use, plug the
value into your main sheet. Copy the results to a second sheet, starting at
row 1. Then with the next value plugged in, copy the results from the main
sheet directly below the first results on the second sheet. Continue doing
this until you exhaust your loop (600 times). I'm guessing this will all fit
on one sheet, even in Excel 2003, because 600 * 80 (lines on one page?) =
48,000 rows required.

Once you have all 600 sets of data on a single sheet, you can set the
horizontal page breaks (again using VBA) to separate the sets of data into
individual pages. Once that's done, you can print just that sheet to a PDF
file, and you'll magically have your 600 pages of data! Then you just delete
that temporary sheet if you no longer need it. You could also add a table of
contents, title page, etc, at the beginning of the temporary sheet if desired.

"The VBA coding is left to the student as an exercise"

HTH,

Eric

"SpeeD" wrote:

Hi.

I need to print the same sheet about 600 times (with different values) to
ONE PDF.
Im thinking of printing the sheet and append the result to an existing PDF.

Is this possible? How can i do this?

Thanks a lot SpeeD