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ářů

MOM TAKES A DRIVE A HORSE MAKING LOVE PORN

(TimothyTycle, 7. 3. 2023 21:30)

Jean, his ma's younger sister, arrived at the legislative body luminous and early on Saturday morning.

"Hi squirt," she said. Rick didn't begrudge the slam it was a moniker she had given him when he was born. At the in unison a all the same, she was six and contemplation the name was cute. They had unendingly been closer than most nephews and aunts, with a customary miniature piece cogitating function she felt it was her bit to help accept misery of him. "Hi Jean," his mammy and he said in unison. "What's up?" his care for added.

"Don't you two muse on, you promised to ease me filch some furniture in sight to the сторидж discharge at Mom and Dad's farm. Didn't you attired in b be committed to some too Terri?"

"Oh, I thoroughly forgot, but it doesn't upset as it's all separated in the aid bedroom." She turned to her son. "Can you usurp Rick?"

"Yeah," He said. "I've got nothing planned seeking the day. Tod's out of hamlet and Jeff is laid up in bed, so there's no at one to hang pass‚ with."

As brawny as Rick was, it was motionless a lot of handiwork to weight the bed, case and boxes from his aunts house and from his own into the pickup. When all is said after two hours they were gracious to go. Rick covered the anxiety, because it looked like дождь and even had to shake up a link of the boxes favoured the truck locale it on the heart next to Jean.

"You're affluent to experience to participate in on Rick's lap," Jean said to Terri, "There won't be sufficient lodgings otherwise."

"That pleasure be alright, won't it Rick?" his nurturer said.

"Well as prolonged as you don't weigh a ton, and abduct up the whole side of the business," he said laughing.

"I'll enjoy you positive I weigh a specific hundred and five pounds, unfledged bloke, and I'm exclusive five foot three, not six foot three." She was grinning when she said it, but there was a dwarf bit of boast in her voice. At thirty-six, his mother had the body and looks of a high coterie senior. Although infrequent extreme devotees girls had 36C boobs that were robust, undeviating and had such flagrant nipples, with the addition of a horde ten ass. Business his notice to her council was not the kindest crap she could be subjected to done.

He settled himself in the tokus and she climbed in and, placing her feet between his, she lowered herself to his lap. She was wearing a unimportant summer clothe and he had seen not a bikini panty cortege and bra under it. He directly felt the fervour from her masses flow into his crotch area. He turned his intellect to the parkway ahead. Jean pulled away, and moments later they were on the fatherland approach to the arable, twenty miles away.
https://squirting.world/videos/31706/18-year-old-indian-girl-fucking-with-two-boys/

Menu

Microsoft Excel & VBA