View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lea Lea is offline
external usenet poster
 
Posts: 4
Default Adobe PDF Writer error


I recently installed Acrobat v6, and now I am having a
problem automatically converting files from Excel to PDF.
The line in question is:

ActiveSheet.PrintOut ActivePrinter:="Adobe PDF on NE00",
PrintToFile:=True, PrToFileName:="C:\Lea\a.pdf"

If I leave off the "PrintToFIle" and the "PrToFIleName",
then it seems to work, except that it prompts me for a
filename to save the pdf. If I try it as is, I get a
nasty error saying that either my port is set up
incorrectly, or I have run out of space.

Has anyone seen this? And does anyone have any
suggestions?

Thanks!