Shell Proces completed?

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

Guest

I have tried (Q129796) to determine when a shelled process ends. I am
currently using SendKeys commands to control Acrobat in "Save As" to JPEG.
the acrobat windows stays open after completion of this task and I can't
determine if the "Save As" is completed. During acrobat operation of the
"Save As", individual files are generated for each PDF page. I think there
is OLE or Automation in Acrobat (No really sure). I have also noticed that I
have the ability to select the following libraris in Access (acrobat, acrobat
access 2.0 type lib, and acrobat distiller).

I need a way to determine the "Save As" operation has completed. Then I
could sendkeys to exit the application.

Your help is appreciated!

Gary
 
Full acrobat supports batch commands for JPEG export and executing javascript
('Advanced' -> 'Batch Processing'). There is also an object you can use with
VB, but hardly any methods work on the Reader. I found the documentation a
bit hard to come by but its titled "Acrobat Interapplication Communication
Overview" (and "Reference"), PDF file names IACOverview.pdf and
IACReference.pdf (they should google).

One way of doing this without the object might be to have a second batch
command create text or other file from the PDF (see save as RTF). Then put a
form timer to monitor for existance of that filename (ie base filename
+_CNV). When the file exists you can continue (maybe you delete it). Or if
you're comfortable with SQL you might do a script like

/* Update Final */
var conn;
var recordset;

try {
conn = ADBC.newConnection("myDSN", "norightsuser", "unsecurepwd");
} catch (exception) {
app.alert("Connection Error.");
}
try {
recordset = conn.newStatement();
} catch (exception) {
app.alert("SQL Statement Error.");
}
try {
recordset.execute("UPDATE tblAdobe SET Final=True");
} catch (exception) {
app.alert("There was an Execution Error.");
}

Where you create myDSN and a norightsuser can only update tblAdobe in your
security group.

Don't think you'll have much luck trying to get adobe to close after
processing.

HTH

Peter
 
Back
Top