Open Acrobat Writer in VBA

[Guest]

I think I can open adobe acrobat using AppActivate?

I wish to direct my access output (from the default printer to the psuedo
acrobat printer) to generate a pdf file. I then wish to open that pdf file
and do a "Save As" to .jpg format.

I would like to accomplish this all using vba code with in access 2k.

Thank You,

Gary

 

[Tim Ferguson]

I then wish to open that pdf file
and do a "Save As" to .jpg format.

You need to know how to manipulate whatever program you are intending to
use for this conversion. My copies of neither Acrobat 4 nor Reader 7 do
it.

You are probably best off using the Shell() command if the program has a
suitable command line option:

strShell = """c:\prog files\converters\convert.exe"" " & _
"H:\pdffiles\mynew.pdf " & _
"/f JPEG2 " & _
"/o a:\mynewpdf.jpg"

' check up help for the arguments to the Shell function
id = Shell(strShell, etc, etc)

If there's an OLE automation interface then it's even easier, but not
many utilities offer it. This is not really an Access or even a VBA
problem: check out your pdf program.

Hope it helps


Tim F