Printing to a 3d party prg and getting it to use a filename I generate in vba

M

Marc Hankin

I save Word docs in a client's subdirectory as
follows:
k:\data\Smith Harvey\Word\Lt09ToHarvey.doc
I often print documents in the Word directory to Acrobat
files, which are stored in the Client's "Scans" directory
as follows:
k:\data\Smith Harvey\Scans\Lt09ToHarvey.pdf
W/much assistance from you folks, I have figured out
how to create a macro that: [1] prints the document to
a "printer" (Adobe Acrobat, or Neevia DocuprinterPro)
that generates Acrobat files, and [2] pastes the desired
fllename and path into the Windows clipboard.
PROBLEM: I don't know how to tell vba to:
1. Wait for the dialog box (that comes from Adobe
Acrobat, or Neevia DocuprinterPro) which asks for the
file name I want to give to the pdf file I'm creating, and
2. then Paste the Windows clipboard into that dialog
box, and
3. then, hit the enter key (in the dialog box that comes
from Adobe Acrobat, or Neevia DocuprinterPro).
Any ideas where I can find the method to accomplish
this?

Thanks,
Marc
 

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