unattended printing of adobe 7.0 files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am looking for this problem for a couple of days. but i can't find a good
solution.
I fill a table with the path to several pdf documents.
By stepping through the table I print the pdf documents.

With this routine not all documents are printed, sometimes we miss one or two.
This my routine.

Dim PDFdoc As String
PDFpath = "c:\program files\adobe\acrobat 7.0\reader\AcroRd32.exe"

Set rst = CurrentDb.OpenRecordset("table")
DoCmd.GoToRecord acActiveDataObject, , acFirst

Do Until rst.EOF
PDFdoc = rst!Document
Call ShellWait(PDFpath & " /p /h" & PDFdoc, 1) 'Print document with
Acrobat Reader
Loop

Is there something wrong with the routine?
Is the problem with adobe 7.0, because we upgraded from adobe 5.
I also tried the shellwait commando, but then adobe doesn't close, and the
user has to close adobe by each print, that is not what we want.

Thanks for the help
 
Have you seen how long it takes to open 7.0 compared to 5.0!

Uninstall all of the Adobe Add-ins.

Use 5.0 instead of 7.0.

Use a different reader instead of Adobe.

Use automation so that you can use just one reader object instead of opening
and closing.

(david)
 
Hi David,
working for an international company doesn't give me the change to work with
5.0.
The made 7.0 the standard.

But what do you mean with automation. Can give me some examples or links
where I can read about this.
 
Back
Top