Using VBA for taking screen shots from PDF file and paste to excel

[dontbugme1]

Hi All,
I am new to VBA and I am working on a project where I require to take screenshots of each pages in a PDF file and paste it to each work sheet in a excel workbook.

I am using acrobat reader to take screenshot. So I was looking for a Code where I can click a button and it would search for a pdf file in a specified folder,take screen shots and paste to individual worksheets.


If anyone can help me out with this it would be very nice.


Regards,
DBM.

[dontbugme1]

Hi all please help me with this......

[dontbugme1]

Hi all,
Please advise me on this..

[jdawson]

Hi. I have a complete Excel application that will prompt you for your PDF, burst it into individual pages and insert them into the active Excel workbook. It does not take a screenshot but instead embeds each single-page entire file into a new sheet.

It uses an old version of PDFTK (no dlls to install) to burst them.

The complete PDFTK zip file is included so I think the licensing is OK. If you would like it please post back and I will email it to you. I don't like attaching zip files to posts on forums nor exposing my email.

Within the same folder as the Excel application is a batch file and PDFTK exe.
The VBA code is (a couple of routines are not used; left over and forgot to delete them; sorry):

Please Login or Register  to view this content.

The DOS Batch file is:

Please Login or Register  to view this content.

Jim