Create code to Run Adobe, Open file, Save and REPEAT

S

Sheila

I need to do the following (Office 2000): Start Adobe Acrobat Reader, Go to
a specified path (which I have already stated). I need to open all of the
files in this directory that are ".tif" files and save them out as ".pdf"
files. Here is the code I have started - which opens Adobe, goes to the
right directory and opens document number 1. This needs to be set to a
variable:


Dim stAppName As String
Dim DocID As String
DocID = "000000000000001"

stAppName = "C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe
\\H2o-data\ScanDocs\Engineering\TapOrders\2002\" + DocID + ".tif"
Call Shell(stAppName, 1)
 

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