Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing to a PDF file from xl
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing to a PDF file from xl
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 -----Original Message----- 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing to a PDF file from xl
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. On Tue, 10 Aug 2004 17:57:01 -0700, "Mark" wrote: -----Original Message----- 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing to a PDF file from xl
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. On Tue, 10 Aug 2004 17:57:01 -0700, "Mark" wrote: 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 -----Original Message----- 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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing to a PDF file from xl
"Steve" wrote:
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing to a PDF file | Excel Discussion (Misc queries) | |||
Printing to PDF file... | Excel Discussion (Misc queries) | |||
printing to file | New Users to Excel | |||
Error 1004 in printing .ps (postscript) file from .xls file | Excel Programming | |||
printing to a PDF file | Excel Programming |