.pdf file automation

[niranjan]

I didnt get you.
Do you want to know how to work with Excel or PDF?

1) To work with PDF:
Adobe provides methods to make the content of a PDF file available to assistive technology
such as screen readers.
On The Microsoft Windows operating system, Adobe Acrobat and Adobe Reader export PDF
content as COM objects. applications can interface with Acrobat or Adobe Reader in two
Ways :
1. Through Microsoft's Active Accessibility( MSAA ) interface, using MSAA objects that
Acrobat or Adobe Reader exorts.
2. Directly through exported COM objects that allow access to the PDF document's
internal structure, called the Document Object Model( DOM ).

The Acrobat SDK is a set of tools that help you develop software that interacts with Acrobat
technology. The SDK contains header files, type libraries, simple utilities, sample code, and
documentation. Using the Acrobat SDK, you can develop software that integrates with
Acrobat and Adobe Reader

You need to have Both Adobe and Acrobat SDK to work with pdf files.
Example:

Code:

Dim gApp, gPDDoc, jso
Set gApp = CreateObject( "AcroExch.App" )
Set gPDDoc = CreateObject( "AcroExch.PDDoc" )
If gPDDoc.Open( "c:\SomePdfFile.pdf" ) Then
Set jso = gPDDoc.GetJSObject()
jso.console.Show
jso.console.Clear
jso.console.println ( "Try doing more research on this...")
gApp.Show
End If
Set jso = Nothing : Set gPDDoc = Nothing : Set gApp = Nothing

2) To Work with Excel:
check this out..
https://www.learnqtp.com/