| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PDF excel document
I created a Macro to PDF certain pages of an Excel sheet using the following
code ActiveWindow.View = xlPageBreakPreview Range("A1:G86,A172:G263").Select Range("A172").Activate Application.ActivePrinter = "Adobe PDF on Ne06:" ActiveWindow.Selection.PrintOut Copies:=1, ActivePrinter:= _ "Adobe PDF on Ne06:", Collate:=True ActiveWindow.View = xlNormalView Range("B7").Select A week later when I went to use the macro it failed as the Printer is now: Adobe PDF on Ne08 How can I set the macro to always find the "Adobe PDF" printer no matter what situation or "Ne" that it sits on?. Iam currently using Adobe Pro 6. As a matter of interest, are there any versions of Adobe writer that allow you to PDF a selection of cells whether contiguous or non-contiguous? Any assistance would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change excel document into word document | Excel Discussion (Misc queries) | |||
| convert excel document to word document (not a picture) | Excel Discussion (Misc queries) | |||
| How to create a formatted 'readable' document based on Excel document? | Excel Discussion (Misc queries) | |||
| I lost a document in excel, the whole document disappeared | Excel Discussion (Misc queries) | |||
| Can you transform an excel document into a word document? | Excel Discussion (Misc queries) | |||
Threaded Mode
