Solved - got my boss to let me have PDF Creator. =P
So I'm using Excel 2003, and I have a strange problem with trying to print directly to Acrobat Distiller. Im not using PDF Creator here, maybe that's my problem.
Any case, using the code below will get me to the regular pop up window asking me where to save the file. This works just fine.
Dim myPath As String
Dim myFileName As String
myPath = "C:\TEST STUDY\DCF\"
myFileName = "test.pdf"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="Acrobat Distiller on Ne04:", Collate:=True
Now if I add in the path where it needs to be saved, the file saves to the correct location, the file becomes corrupted.
Dim myPath As String
Dim myFileName As String
myPath = "C:\TEST STUDY\DCF\"
myFileName = "test.pdf"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="Acrobat Distiller on Ne04:", Collate:=True, PrToFileName:=myPath & myFileName
Any idea what's going on here?
Thanks for your help
Z
Bookmarks