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.
Now if I add in the path where it needs to be saved, the file saves to the correct location, the file becomes corrupted.
Any idea what's going on here?
Thanks for your help
Z
Bookmarks