printing to a PDF file from xl

[Steve]

I would like to print to a pdf file from xl. When I hit
print it asks for a name to save the pdf file to. I have
about 100 pages that I will be doing this for, I don't
want to have to type in each page name.

how do I, using vba, tell xl what to name the file.

Thanks
steve

 

[Mark]

i am on the fly at the moment and just want to say that if
you use the .PDF extension, it does not mean that it is
Acrobat compatible. You need to copy and paste the data
into a new Acrobat sheet or import directly from Acrobat.

Acrobat reader is only a reader, not a program.
PS Why PDF anyway? why not .doc?
Word is just as good if not better...I bet you are a
teacher or with the education department.

regards
Mark

 

[Myrna Larson]

What version of Acrobat are you using? In version 6, I can go to Control
Panel, select Printers, then right-click the Adobe PDF "printer". From the
menu, select Properties, then Printing Preferences. In the next dialog box you
can "uncheck" the box to ask for a file name.

I believe that the default file name is the document name with a PDF
extensions.

Of course this won't work for you if your 100 "pages" are worksheets within
the same workbook.

 

[Myrna Larson]

If your 100 pages are separate files (as opposed to worksheets within one XLS
file), you can find information on the Adobe web site on printing multiple
documents.

 

[Guest]

I would like to print to a pdf file from xl. When I hit
print it asks for a name to save the pdf file to. I have
about 100 pages that I will be doing this for, I don't
want to have to type in each page name.

I found a fix to this problem, that works in Office 2000 anyway...

Each worksheet is created from a single worksheet.
Right click on the target worksheet, "Move or Copy", check "Make a Copy".

DON'T Insert->Worksheet.
DON'T populate more than a single worksheet that is to be printed from the
auto-generated ones.

Then format away. The result for me was a five page, single pdf, three
pages portrait, and two pages landscape (with graphics). Before applying
this trick, I had three individual pages (each as their own pdf) and a pair
of pages that had been copied one from the other (which was the clue)

Yes, it is a pain in the tush to copy the contents and the column widths
from existing spreadsheets, but it does pay off...