Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pdf file in a UserForm
Is there a way to insert a .pdf file in a UserForm and be able to scroll
through the pages? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pdf file in a UserForm
From the VBA Toolbox Right clickAdditional Controls check 'Adobe PDF
Reader' form the list of available controls. Drag the control to the user form and use the below code to load the PDF. Private Sub CommandButton1_Click() With Me.AcroPDF1 .LoadFile "d:\ProjectPlan_Website.pdf" .SetShowToolbar (False) .GotoFirstPage End With End Sub -- Jacob "Phil H" wrote: Is there a way to insert a .pdf file in a UserForm and be able to scroll through the pages? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pdf file in a UserForm
Hi Jacob, thanks for your reply. In this project, I have two other
UserForms with imbedded TextBoxes, activated by the user clicking on an "information" autoshape hyperlinked to the code. I want to do the same here - but isn't your code looking for the .pdf outside the workbook? I need to have the .pdf located in the Excel workbook the same way as the TextBox is imbedded in the UserForm. "Jacob Skaria" wrote: From the VBA Toolbox Right clickAdditional Controls check 'Adobe PDF Reader' form the list of available controls. Drag the control to the user form and use the below code to load the PDF. Private Sub CommandButton1_Click() With Me.AcroPDF1 .LoadFile "d:\ProjectPlan_Website.pdf" .SetShowToolbar (False) .GotoFirstPage End With End Sub -- Jacob "Phil H" wrote: Is there a way to insert a .pdf file in a UserForm and be able to scroll through the pages? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform won't show after closing another file | Excel Discussion (Misc queries) | |||
Best Way to Get File Names into UserForm | Excel Programming | |||
How to embed a PDF file into a userform | Excel Programming | |||
Saving contents of a Userform to another file. | Excel Programming | |||
UserForm Pops Up when in the wrong file. | Excel Programming |