PDF thumbnails from VBA

I was asked to develop a form where user can see a pdf thumbnail of a pdf file. It was pretty far from what I have been developing so I decided to use "uncle" google to find a solution. There are some solutions but nothing what was expecting. You can use paid version of Adobe or free Adobe Acrobat ActiveX (Acropdf1) or some others free tools that can work along a pdf file. I tested only the free version of Acrobat ActiveX component and it was really nightmare. Then I found a C# project using the GhostScript tool for creating a pdf thumbnail. Unfortunatelly VBA cannot work with this project directly. Read more to find solution.

As I mentioned you can use the Acropdf1 activeX which is automatically installed with the Adobe Reader application.

Acropdf1.PNG, 35kB

How to add the Acropdf1 activeX on a VBA form

At the first time the activeX seemed to be a good solution but then I found two "bugs". The first one is more important than the second one. The activeX takes focus and never give it back and if you press the "TAB" key, then the whole application will crash. It's very known bug but Adobe cannot fix it for some reason. And the second bug rather behavior - of the activeX control is uncomfortable - it always takes focus and never give it back and also you don't have option to find out if a pdf document is fully loaded or not. My client was complaining about that for many times so I decided to find another solution.

I found code from Matthew Ephraim. where he uses a free tool Ghostscrip and .NETFramework 3.5 and C#. Form Visual Studio you can use his tool without any problems just include it into your project. Unfortunately we cannot use his dll directly from VBA. That was the reason why I took his code and made a little adjustment to expose methods from his project to the COM object.
Now - after registration the dll to your system - you can reference the dll as usually and use it !!! And it works great.

GhostScriptSharp_reference.PNG, 17kB

Who is interested how to create a C# dll that can work with VBA I attached the zip file with entire C# solution. Look at the Attachment section.
And who just want to use it as soon as possible, download the installer and install it. I also prepare a sample and you can find everything in the Attachment section.
The installer just check if your system contains the .NETFramework 4 and if not, it will suggest to download it and then register the dlls into your system.

Your code can look like this one
and then you can take the output file as an ordinary image file and load it - for example - to an image control.

Option Explicit
'********************************************************************************
'TestPDFThumbnailGeneration
'
' Purpose:  It uses reference to GhostscriptWrapper library.
'           From a pdf file creates a jpg file that represents a thumbnail of the pdf.
'           You can set page number and DPI quality.
'
' Inputs:   -none-
'
' Outputs:  -none-
'
' Created:  02/10/2011  Premysl Lazecky
'
' Modified: .
'
'********************************************************************************
Sub TestPDFThumbnailGeneration()

    Dim PDF             As GhostscriptWrapper
    Dim strPath         As String
    Dim strInputFile    As String

    strInputFile = "Test.pdf"
    strPath = ActiveWorkbook.Path
    If Right$(strPath, 1) <> Application.PathSeparator Then
       strPath = strPath & Application.PathSeparator
    End If

    Set PDF = New GhostscriptWrapper

    PDF.GeneratePDFThumb inputPath:=strPath & strInputFile, _
                         outputPath:=strPath & "Output.jpg", _
                         Page:=1, _
                         Width:=72, Height:=72


    Set PDF = Nothing

End Sub

As the result of this code you will get a jpg file called Output.jpg with thumbnail of defined page in the pdf file - in this case page 1 - with defined resolution.

Attachments

Installer and sample files
C# project

Komentáře

Přehled komentářů

hello

(Albertsaste, 1. 5. 2021 2:07)

The one we are most regarding is the hot, spicy cassia cinnamon we get from our local grocery store. Its heat emanates from coumarin, this particular substance has effects it is advisable to understand if you're going also included with it as the daily supplement and not just for a flavoring.

There was hardly anybody who would not like seem beautiful. About the period time beauty slowly fades away owing to age and what's left are indication of aging. To combat these signs, people use numerous methods like anti-aging creams, Botox, amongst others. They aim to keep their beauty (which they believe is physical) intact for as long probably. This is the place where they fool themselves into believing they are a product of natural beauty. They earn to get dazzling and remain the centre of attraction.

I'm not talking about those citizens. There is a problem in our country, and throughout planet for that matter, features created more health issues for those with less. That isn't something I will deny and also argue. Things i will argue is that being health does not need to be more expensive money.

Appreciating and enjoying these healthy connections is unequalled. As life comes close with regard to an end it is the experience of these wholesome socially rich environment that discover a method to matter alot more than personal possessions.

Random House dictionary, defines "beauty" as the characteristic within a person, place, object or concept provides a perceptual example of pleasure, meaning or satisfaction to head or to your eyes, arising from sensory manifestations such as being a shape, color, personality, sound, design or rhythm.
Whilst enough time assume that poor as well as wellness disease undoubtedly matter of bad luck, that typically not situation. Of course number of obvious some the different parts of bad luck involved in ill health, like genetics, but even then taking care of your health can go some way towards overcoming your bad luck.

The beauty pageant in the late nineties created a sensation inside the world when around seven Indian girls became beauty queen while participating numerous beauty pageants. The pageant sash itself became a part model for many girls every where. The Indian girls started loving associated with them. Today there is beauty pageant being organized in every nook and corner of India, had been considered backward by western countries till 1990. Even you notice the beauty pageant being organized in the very center and small cities. The ladies of these cities do not hesitate location on the pageant sash. So the sash is really part every and every society and females love to flaunt it while enrolled in different beauty events from their college energy.

Menu

Microsoft Excel & VBA