![]() Microsoft Excel VBA Fact Sheet: Build a UserForm for Excel ): ). Hi there I saw a post the other day with someone asking how to show or embed an acrobat file in a userform. I can't remember who it was that posted but I thought I would put this up just in case they are on line having a look. This works with Excel 2000 SP3 and Acrobat reader 6 I can't tell you if it will work with any other versions as I don't have them to test. In the VBE>Tools Menu>References check the checkbox for 'Acrobat control for ActiveX'. Then on your toolbox right click and select addition controls and again check the 'Acrobat control for ActiveX' checkbox. This will add an adobe acrobat control to your toolbox. Drag a PDF control on to a user form and then add the following code Option Explicit Private Sub UserForm_Initialize() Pdf1.LoadFile ('C: Test excel vba.pdf') ' you can use this to turn the toolbars on and off Pdf1.setShowToolbar False End Sub ' when you unload the form you need to close the PDF before doing so or acrobat will ' give you an error. I'm not sure if this is the best way but it worked for me. Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) Pdf1.LoadFile (') End Sub Hope this is of some help. • • • • • • • • • • • Important Notice: Hire Help Rules Dear, please note that the terms and conditions of the HIRE HELP forum have been updated and can be found here ( ) as well as in the forum description. We ask you to familiarize yourself and contact admin if you have any questions. - OzGrid Administrators • If this is your first visit, be sure to check out the by clicking the link above. Call of duty 4 patch 1.6 and 1.7. You may have to before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, or log in above. Full version battle realms.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |