PDF Active X in Microsoft excel

[varoon]

I want to view pdfs in microsoft excel using active x controls. i have designed a window using control toolbox available in excel 2003. can assist me for viewing the pdf in that window. i am novice and know very less of activex controls..

 

[Andrew Poulsom]

Welcome to the Board.

You can use Insert|Object to insert the PDF file as an icon and doublle click to view it.

Or you can add a Web Browser Control and a CommandButton:

Private Sub CommandButton1_Click()
'***Change to suit
    Const FileName As String = "P:\Temp\PDFFile.pdf"
    WebBrowser1.Navigate FileName
End Sub

 

[varoon]

I doesn't work.. there is an error saying object missing. is it possible to use active x and open it within excel rather than html browser

 

[Andrew Poulsom]

What doesn't work? When do you get the error? The Web Browser Control is an ActiveX control isn't it?

 

[varoon]

I couldn't find the web browser activex control in the toolbox..
Instead i tried using acrobat adobe reader activex.

Private Sub AcroPDF1_GotFocus()
AcroPDF1.Visible = True
fileNameX = "C:\Documents and Settings\ar\Desktop\1.pdf"
AcroPDF1.LoadFile fileNameX
sub

This also doesn't work. when i hover / click the embeded window in the excel sheet. there is no preview

 

[varoon]

thanks,
i got it and it worked