Open an existing PDF document from using OLE automation

Posted on 2004-09-28
Last Modified: 2008-01-09

I want to open an existing PDF file using OLE automation.

I have built a project which allows the user to open Word and Excel templates.

I am using the following code to open Word/Excel:

Dim wordApp as Word.Application
Dim wordDoc as Word.Document
wordApp = New Word.Application
wordApp.Visible = True
wordDoc = wordApp.Documents.Add

I would ideally like the reference needed as well as the code to access the pdf file.


Question by:GarethWham
  • 5
  • 4
  • 2
  • +3

Expert Comment

ID: 12168299
I don't think that you can actually open pdf file with VB, because the pdf format is property of Adobe. I am sure that you could export data in this format (I' ve done it), there are no generic methods to edit pdf file in VB.

Try searching for an open source component that edits files - may find one out there.

If you are trying to open the pdf file Fron your app with Acrobat Reader then use

ShellExecute(hwnd, "Open", "filename.pdf", 0&, 0&, SW_SHOW)  

Expert Comment

ID: 12168377
Sorry - SW_SHOW is not defined in VB, old c++ :)
try 5 istead

Expert Comment

ID: 12168385
The way suggested by Daniel would intern would actually depend on Adobe Acrobat reader being installed over there on the machine and also its not Win32 automation .
Gareth can you please give more exact specs abt why you need a word document to open a PDF file. Infact, if you need to extract text or image from pdf there is free source code available on the next.
The source code for one of the tools is available at

it inturn depends on XPDF library obtained at following url

Best of luck!

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.


Author Comment

ID: 12168584
I just need to open a pdf file from I may be able to use shell. Thanks for your comments, will let you know how I get on

Author Comment

ID: 12168809
I have managed to use the shell function to open adobe reader which is:

Shell ("C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe")

Now, does anyone know the switch to open a pdf file.

For example, when you shell a word template the switch is \t (then the path of the template)

I want to put in a switch to open an existing file any ideas?

Many thanks

Expert Comment

ID: 12168889
Actually there is no need to start the acrord.exe .
After you are using the  shell routine just use:

shell ("start " +<file paht and name>,,,,,);
The string filename.pdf must include
 The default app for the file is autostarted

Expert Comment

by:Amritpal Singh
ID: 12168928
plz visit the following link
i hope it'll be of any help

Author Comment

ID: 12169128

That doesn't seem to work. I am using the following code.

("start""C:\Documents and Settings\J Smith\Publications\FileName.pdf")

Is there a reference I need to use?


Expert Comment

ID: 12169210
Well you've got to add + between the two strings:)

Expert Comment

ID: 12169228
and put  space char after start the string should be:

"start C:\Documents and Settings\J Smith\Publications\FileName.pdf" or

"start " + "C:\Documents and Settings\J Smith\Publications\FileName.pdf"

Accepted Solution

Jojo1771 earned 500 total points
ID: 12169264
Here is How I open pdfs for my projects. This will try version 6 or 5 then just try to open file based off what its associated with..

'function to determine adobe version and use that version. 6 or 5
    Function Readeropen(ByVal FiletoOpen As String)
            Shell("C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe " & FiletoOpen, AppWinStyle.MaximizedFocus)
        Catch ex As Exception
                Shell("C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe " & FiletoOpen, AppWinStyle.MaximizedFocus)
            Catch ex2 As Exception
                Catch ex3 As Exception
                    MsgBox("Adobe Acrobat Reader v5.0 or higher can not be found.", MsgBoxStyle.Exclamation, "Reader missing.")
                End Try
            End Try
        End Try

    End Function

Author Comment

ID: 12169713
Cheers all,

Sorted by using the following:

Shell ("Full File Path to Adobe Executable File & Full File Path to PDF File")


Expert Comment

ID: 12171784
system.diagonistics or what ever it is called.
needs to be included to do

This will open the file with the associated app.

Just incase the shell one dosn't always work.

Thanks and GL

Expert Comment

ID: 12411083
If you own Acrobat 6.0, you can reference the acrobat.tlb Acrobat Type Library.  I don't think it is available with the free 6.0 reader though.

This is part of my code that I use to merge .PDF files.

        Dim AcroApp As Acrobat.CAcroApp
        Dim PDDoc As Acrobat.CAcroPDDoc
        Dim InsertPDDoc As Acrobat.CAcroPDDoc
        Dim iNumberOfPagesToInsert As Integer, iLastPage As Integer
        Dim goRound As Integer, strOutput As String, strTest As String

        On Error GoTo ErrorHandler
        AcroApp = CreateObject("AcroExch.App")
        PDDoc = CreateObject("AcroExch.PDDoc")
        InsertPDDoc = CreateObject("AcroExch.PDDoc")

Hope this helps.

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Apps blocked by Java 9 88
Is doing teaching in my situation advisable? 2 111
Query group by data in SQL Server - cursor? 3 48
collection output issue 9 37
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question