Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Similar PDF generation Problem
Hello All,
I have aproblem similar to many I've read on generating a PDF to a filename, but the suggestions for the other posts that I've read don't seem to be working for me. Any help would be greatly apprecited. I'm using Excel 2003 SP1 & Adobe Acrobat 7.0 Professional version 7.0.7 What's happening: I get a Preview File that looks fine. But when I try to open the file generated, I get the message "Acrobat could not open 'di02000_cp1.pdf' because it is either not a supported file type or because the file has been damaged.....To create an Adobe PDF document, go to the source applicatio. Then print the document to Adobe PDF." Here is my code: Sub PrintPDF() directory2use = "\\dsks48\process\" filename2use = directory2use + "di02000_cp1.pdf" Application.ActivePrinter = "Adobe PDF on Ne03:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:= _ True, ActivePrinter:= "Adobe PDF on Ne03:", PrintToFile:= _ True, Collate:=True, PrToFilename:=filename2use End Sub Any suggestions? Thanks in advance, Cindy W. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calender Generation | Excel Discussion (Misc queries) | |||
Key Generation | Excel Discussion (Misc queries) | |||
Similar Problem as "Multiple Matched Lines" | Excel Discussion (Misc queries) | |||
Row ID generation | Excel Programming | |||
similar problem to moving to next cell | New Users to Excel |