Converting a PDF file to TIFF programatically

[bCloud9c]

Here is my situation. I have converted an Access report to a PDF file and
saved it to a specific location via Lebans new reportToPDF. I also need to
save this file as a TIFF file. I tried copying it and renaming it as xxx.TIF
and I get an invalid format error. Am I going about this the wrong way?
Thanks for your input!

 

[Duane Hookom]

You might want to consider www.Snagit.com. This is an unbelievably useful
program that can capture your printer output. SnagIt then allows you to save
the file in tons of different file formats. The program does cost $40 but
not much compared with its value.

 

[bCloud9c]

I actually can't buy third party software and install it on my computer here
at work. It is a very annoying problem b/c I know there are tons of third
party add-ins to convert file types. Is there any other way of doing this
within MS Access without having to buy third party software? Thanks!

You might want to consider www.Snagit.com. This is an unbelievably useful
program that can capture your printer output. SnagIt then allows you to save
the file in tons of different file formats. The program does cost $40 but
not much compared with its value.

Here is my situation. I have converted an Access report to a PDF file and
saved it to a specific location via Lebans new reportToPDF. I also need

[quoted text clipped - 3 lines]

and I get an invalid format error. Am I going about this the wrong way?
Thanks for your input!

 

[Duane Hookom]

I am not sure of any method since you can't install any software. Possibly
hire a consultant to do the conversion for you and then send the bill to the
folks who don't allow you to install software or possibly won't install it
for you.

--
Duane Hookom
MS Access MVP
--

I actually can't buy third party software and install it on my computer
here
at work. It is a very annoying problem b/c I know there are tons of third
party add-ins to convert file types. Is there any other way of doing this
within MS Access without having to buy third party software? Thanks!

You might want to consider www.Snagit.com. This is an unbelievably useful
program that can capture your printer output. SnagIt then allows you to
save
the file in tons of different file formats. The program does cost $40 but
not much compared with its value.

Here is my situation. I have converted an Access report to a PDF file
and
saved it to a specific location via Lebans new reportToPDF. I also need

[quoted text clipped - 3 lines]

and I get an invalid format error. Am I going about this the wrong way?
Thanks for your input!

 

[bCloud9c]

Guess I'm just out of luck with automating the PDF to TIFF part of the
process. They'll just have to manually go and convert it throught Acrobat.
Thanks for the help Duane.

I am not sure of any method since you can't install any software. Possibly
hire a consultant to do the conversion for you and then send the bill to the
folks who don't allow you to install software or possibly won't install it
for you.

I actually can't buy third party software and install it on my computer
here

[quoted text clipped - 14 lines]

 

[Duane Hookom]

I expect Stephen Lebans might be reading through this thread at some point.
I'm sure if there is a way to accomplish what you want without installing
software, he would be the person with the solution or at least a nudge in
the right direction.

--
Duane Hookom
MS Access MVP
--

Guess I'm just out of luck with automating the PDF to TIFF part of the
process. They'll just have to manually go and convert it throught
Acrobat.
Thanks for the help Duane.

I am not sure of any method since you can't install any software. Possibly
hire a consultant to do the conversion for you and then send the bill to
the
folks who don't allow you to install software or possibly won't install it
for you.

I actually can't buy third party software and install it on my computer
here

[quoted text clipped - 14 lines]

and I get an invalid format error. Am I going about this the wrong
way?
Thanks for your input!

 

[Guest]

Isn't the MS Office document writer a TIFF printer? Are
you willing/able to install and use that?

(david)

 

[SA]

bCloud:

You can use Acrobat's java script combined with its InterApplication
Communication support to automate (via VBA) saving a PDF as a TIFF (it will
convert one tiff file per page). The code looks like this:

Hope this helps
--
SA
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

'---------- Begin PDF to TIFF code -------------
Public Function SavePDFAsTIFF(Optional strPDFFileName As String)
Dim objAcro As Object
Dim objAvDoc As Object
Dim objPDdoc As Object
Dim objJso As Object

Set objAcro = CreateObject("AcroExch.App")
If Len(strPDFFileName) < 1 Then
'Reference the first PDF doc currently open
Set objAvDoc = objAcro.GetAvDoc(0)
Else
Set objAvDoc = CreateObject("AcroExch.AVDoc")
objAvDoc.Open strPDFFileName, "DocToConvert"
End If
Set objPDdoc = objAvDoc.GetPDDoc
Set objJso = objPDdoc.GetJSObject
objJso.SaveAs "c:\your folder\test.tiff", "com.adobe.acrobat.tiff"

objPDdoc.Close
objAvDoc.Close (False)
Set objJso = Nothing
Set objPDdoc = Nothing
Set objAvDoc = Nothing
Set objAcro = Nothing
End Function
'-------------------------------------

End Function

Guess I'm just out of luck with automating the PDF to TIFF part of the
process. They'll just have to manually go and convert it throught
Acrobat.
Thanks for the help Duane.

I am not sure of any method since you can't install any software. Possibly
hire a consultant to do the conversion for you and then send the bill to
the
folks who don't allow you to install software or possibly won't install it
for you.

I actually can't buy third party software and install it on my computer
here

[quoted text clipped - 14 lines]

and I get an invalid format error. Am I going about this the wrong
way?
Thanks for your input!

 

[SA]

Greetings Duane:

See my post in this thread for the VB to do this with Acrobat....

Steve Arbaugh

I expect Stephen Lebans might be reading through this thread at some point.
I'm sure if there is a way to accomplish what you want without installing
software, he would be the person with the solution or at least a nudge in
the right direction.

--
Duane Hookom
MS Access MVP
--

Guess I'm just out of luck with automating the PDF to TIFF part of the
process. They'll just have to manually go and convert it throught
Acrobat.
Thanks for the help Duane.

I am not sure of any method since you can't install any software.
Possibly
hire a consultant to do the conversion for you and then send the bill to
the
folks who don't allow you to install software or possibly won't install
it
for you.

I actually can't buy third party software and install it on my computer
here
[quoted text clipped - 14 lines]
and I get an invalid format error. Am I going about this the wrong
way?
Thanks for your input!

 

[Jose Hernandez]

How about GhostScript http://www.cs.wisc.edu/~ghost/ it can convert PDF's
to Tiffs, It's free.

- Jose

 

[Stephen Lebans]

I'm going to be adding Tiff support in one of the upcoming versions. I
already have the code over in my LoadJpegGif project using the GDI+ so I
just have to copy it over and integrate it into the ReportToPDF project.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

I expect Stephen Lebans might be reading through this thread at some point.
I'm sure if there is a way to accomplish what you want without installing
software, he would be the person with the solution or at least a nudge in
the right direction.

--
Duane Hookom
MS Access MVP
--

Guess I'm just out of luck with automating the PDF to TIFF part of the
process. They'll just have to manually go and convert it throught
Acrobat.
Thanks for the help Duane.

I am not sure of any method since you can't install any software.
Possibly
hire a consultant to do the conversion for you and then send the bill to
the
folks who don't allow you to install software or possibly won't install
it
for you.

I actually can't buy third party software and install it on my computer
here
[quoted text clipped - 14 lines]
and I get an invalid format error. Am I going about this the wrong
way?
Thanks for your input!

 

[Duane Hookom]

I kinda figured it was on some "to do" list.

--
Duane Hookom
MS Access MVP
--

I'm going to be adding Tiff support in one of the upcoming versions. I
already have the code over in my LoadJpegGif project using the GDI+ so I
just have to copy it over and integrate it into the ReportToPDF project.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

I expect Stephen Lebans might be reading through this thread at some
point. I'm sure if there is a way to accomplish what you want without
installing software, he would be the person with the solution or at least
a nudge in the right direction.

--
Duane Hookom
MS Access MVP
--

Guess I'm just out of luck with automating the PDF to TIFF part of the
process. They'll just have to manually go and convert it throught
Acrobat.
Thanks for the help Duane.

Duane Hookom wrote:
I am not sure of any method since you can't install any software.
Possibly
hire a consultant to do the conversion for you and then send the bill to
the
folks who don't allow you to install software or possibly won't install
it
for you.

I actually can't buy third party software and install it on my computer
here
[quoted text clipped - 14 lines]
and I get an invalid format error. Am I going about this the wrong
way?
Thanks for your input!

 

[bCloud9c via AccessMonster.com]

SA,

Can you show me the code you are talking about for the VBA automation of PDF
to TIFF? Thanks.

bCloud:

You can use Acrobat's java script combined with its InterApplication
Communication support to automate (via VBA) saving a PDF as a TIFF (it will
convert one tiff file per page). The code looks like this:

Hope this helps

Guess I'm just out of luck with automating the PDF to TIFF part of the
process. They'll just have to manually go and convert it throught

[quoted text clipped - 13 lines]

 

[SA]

It was in my post, below my sig., but here it is again.

'---------- Begin PDF to TIFF code -------------
Public Function SavePDFAsTIFF(Optional strPDFFileName As String)
Dim objAcro As Object
Dim objAvDoc As Object
Dim objPDdoc As Object
Dim objJso As Object

Set objAcro = CreateObject("AcroExch.App")
If Len(strPDFFileName) < 1 Then
'Reference the first PDF doc currently open
Set objAvDoc = objAcro.GetAvDoc(0)
Else
Set objAvDoc = CreateObject("AcroExch.AVDoc")
objAvDoc.Open strPDFFileName, "DocToConvert"
End If
Set objPDdoc = objAvDoc.GetPDDoc
Set objJso = objPDdoc.GetJSObject
objJso.SaveAs "c:\your folder\test.tiff", "com.adobe.acrobat.tiff"

objPDdoc.Close
objAvDoc.Close (False)
Set objJso = Nothing
Set objPDdoc = Nothing
Set objAvDoc = Nothing
Set objAcro = Nothing
End Function
'-----------------------------------

SA,

Can you show me the code you are talking about for the VBA automation of
PDF
to TIFF? Thanks.

bCloud:

You can use Acrobat's java script combined with its InterApplication
Communication support to automate (via VBA) saving a PDF as a TIFF (it
will
convert one tiff file per page). The code looks like this:

Hope this helps

Guess I'm just out of luck with automating the PDF to TIFF part of the
process. They'll just have to manually go and convert it throught

[quoted text clipped - 13 lines]

way?
Thanks for your input!

 

[Brandon via AccessMonster.com]

The code compiles fine and runs without error, but the file just stays in
adobe format. What am I doing wrong?

It was in my post, below my sig., but here it is again.

'---------- Begin PDF to TIFF code -------------
Public Function SavePDFAsTIFF(Optional strPDFFileName As String)
Dim objAcro As Object
Dim objAvDoc As Object
Dim objPDdoc As Object
Dim objJso As Object

Set objAcro = CreateObject("AcroExch.App")
If Len(strPDFFileName) < 1 Then
'Reference the first PDF doc currently open
Set objAvDoc = objAcro.GetAvDoc(0)
Else
Set objAvDoc = CreateObject("AcroExch.AVDoc")
objAvDoc.Open strPDFFileName, "DocToConvert"
End If
Set objPDdoc = objAvDoc.GetPDDoc
Set objJso = objPDdoc.GetJSObject
objJso.SaveAs "c:\your folder\test.tiff", "com.adobe.acrobat.tiff"

objPDdoc.Close
objAvDoc.Close (False)
Set objJso = Nothing
Set objPDdoc = Nothing
Set objAvDoc = Nothing
Set objAcro = Nothing
End Function
'-----------------------------------

SA,

[quoted text clipped - 15 lines]

 

[SA]

Brandon:

Don't know if you are doing anything wrong. The PDF file is retained, it
just creates TIFF files in the target directory, one per page; this does
required Acrobat 5 and above, tested with 6 and 7....
--
SA
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

The code compiles fine and runs without error, but the file just stays in
adobe format. What am I doing wrong?

It was in my post, below my sig., but here it is again.

'---------- Begin PDF to TIFF code -------------
Public Function SavePDFAsTIFF(Optional strPDFFileName As String)
Dim objAcro As Object
Dim objAvDoc As Object
Dim objPDdoc As Object
Dim objJso As Object

Set objAcro = CreateObject("AcroExch.App")
If Len(strPDFFileName) < 1 Then
'Reference the first PDF doc currently open
Set objAvDoc = objAcro.GetAvDoc(0)
Else
Set objAvDoc = CreateObject("AcroExch.AVDoc")
objAvDoc.Open strPDFFileName, "DocToConvert"
End If
Set objPDdoc = objAvDoc.GetPDDoc
Set objJso = objPDdoc.GetJSObject
objJso.SaveAs "c:\your folder\test.tiff", "com.adobe.acrobat.tiff"

objPDdoc.Close
objAvDoc.Close (False)
Set objJso = Nothing
Set objPDdoc = Nothing
Set objAvDoc = Nothing
Set objAcro = Nothing
End Function
'-----------------------------------

SA,

[quoted text clipped - 15 lines]

way?
Thanks for your input!

 

[Brandon via AccessMonster.com]

SA,

I have looked in the target directory and no TIFF file seems to be showing up.
Is there a reference that I need to add to my references?

-Brandon

Brandon:

Don't know if you are doing anything wrong. The PDF file is retained, it
just creates TIFF files in the target directory, one per page; this does
required Acrobat 5 and above, tested with 6 and 7....

The code compiles fine and runs without error, but the file just stays in
adobe format. What am I doing wrong?

[quoted text clipped - 34 lines]