Exactly what is your problem?
Does your VBA script place the files in the expected watched folder?
Does distiller fail to distill the created file?
Do you keep the log files on failure?
Distiller does not find the watched directory?
What is the version of MS Office that you are using?
For watched files, ever since version 4, there are 2 added subdirectories to the watched folder an 'IN" and "OUT" both created by distiller. The PS file goes into the "In" directory and the PDF, PS and log are placed in the 'Out' subdirectory. I would expect your directory to the 'in' directory for the watched folder 'C:\Documents and Settings\X646894\EPEPEBuild' would have to be
C:\Documents and Settings\X646894\EPEPEBuild/PostScript/in/*.ps
Great to hear from you.
The Microsoft Access program is Microsoft Access 2003
The VBA Code sends a series of ps files to the folder:
C:\Documents and Settings\X646844\EPEPEBUild\Postscript
the files created are titled:
001.ps; 002.ps; 003.ps; ... Nnn.ps
When a complete set of ps files are created for a specific customer the text shown in the txt files I've attached is sent to the same directory. With Distiller 7 and 8 this caused Distiller to combine the ps files into a single pdf and name it based on the information in the text file.
With the conversion to Distiller X, this no longer works.
Any ideas you can provide are sincerely appreciated.