you wanted to copy all the text from pdf file to excel you images as well
if it matter of copy text in excel sheet with proper formating
you have to use 3rd party activex called SII_pdf and it will convert
PDF file to Text with Command line it means we can use it in our macro
anywhere in batch
Could you please send images in .PNG format instead of .BMP.
would be much more lighter in size, try it.
On Tue, Apr 21, 2009 at 12:47 PM, Ajay Varshney wrote:
> Hi,
>
> I have problem in using the given code. I am using two codes one for
> opening the pdf file and second for copy the data from
Hi Ajit,
I can keep any name for the pdf file and save it anywhere as required. I
have many pdf files for picking data. From each file I take data from
different page. If I get code for one file then I can write the same code
for other files also (with some edition). Area to be taken will be diffe
Ajay,
If you have Acrobat 7.0/8.0/9.0 installed on your computer, then a code like
the following will do.
You need to create a reference to Acrobat.TLB.
''
Dim APDF As New AcroPDDoc
Dim APG As AcroPDPage
Dim APOINT As AcroPoint
Dim ARect As New AcroRect
Ajay,
I am working on this. Pls let me know how you are going to specify the file
name, page number and the area from the page that you want to copy and
paste. Also let me know if you are using any ActiveX Controls that view PDF
files..
Ajit
From: excel-macros@googlegroups.com [mailt
