unattended printing of adobe 7.0 files

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
 
G

Guest

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)
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top