Previous | Next | (P-PDF) Acrobat 6.0

Topic: Changed from Acrobat 5.0 to 6.0 and having problems Creating Postscript File from VBA code
Conf: (P-PDF) Acrobat 6.0, Msg: 112168
From: Jotham
Date: 5/26/2004 11:53 PM

I was using the following codr when creating a PS file from Acrobat Distiller in 5.0. I just upgraded to 6.0 Standard but the same code is not processing my PS file.

Code Being Used:

Dim PSFileName As String
Application.ActivePrinter = "Acrobat Distiller on Ne00:"
Application.Goto Reference:="r1c1"
Let PSFileName = Application.ActiveCell
SendKeys PSFileName & "{ENTER}", False
Sheets("ECN FacePage").PageSetup.PrintArea = "$F$5:$R$55"

SheetsWorksheets.PrintOut , PrintToFile:=True
PSFileName = Chr(34) & PSFileName & Chr(34)