![]() Ret = Sheet1.FoxitPDFSDK 1.OpenFile (“E:\foxit\SE\f20.pdf”, “”) Make changes to the code below to match the path of a PDF on your desktop:.Sub AddFoxitPDFSDKPro ( ) Dim Target As Range Set Target = Cells( 1, 4) Set WSheet = ThisWorkbook.Worksheets ("Sheet1") Set MyPDFSDK = ( ClassType :=" Foxit.FoxitPDFSD KProCtrl.5", Link:=False, DisplayAsIcon :=False, Left:= Target.Left, Top:= Target.Top, Width:=400, Height:= 600) End Sub Sub OpenFile ( ) Dim ret ret = Sheet1.FoxitPDFSDK 1.OpenFile ("E:\foxit\SE\f20.pdf", "") Sheet1.FoxitPDFSDK 1.GoToPage (2) End Sub In the Project View, select ThisWorkbook and copy and paste the code below.Note: You may need to change the file type to. ocx and press open, then press okay to add the reference. Browse to the folder where you have the Foxit ActiveX’s OCX located at and select the.Go to File->Option->Customize Ribbon-> Check the Developer tab to add it Note: If you do not have the Developer tab. Save and run it using the run button in Visual Basic Editor.Change the page in the code from “E:\foxit\SE\test.pdf” to an existing path on your machine.Sub OpenFile ( ) Dim ret ret = Sheet1.FoxitPDFSDK 1.OpenFile ("E:\foxit\SE\test.pdf ", "") Sheet1.FoxitPDFSDK 1.FindFirst (“ myTextString ”, False, False) Sheet1.FoxitPDFSDK 1.GoToPage (0) End Sub Copy the following code to the “ ThisWorkbook ” of the project.Select the region in the Excel or Access Sheet which you want the control to appear.Go to DEVELOPER->Insert-> ActiveX Controls-> More Tools->choose FoxitPDFSDK Pro Control.Foxit ActiveX comes in both 圆4 and x86 ocx.ocx and press open, then press okay to add the reference.Note : You may need to change the file type to. In the Microsoft Visual Basic for applications, select Tools->Reference->Browse….Select DEVELOPER->Visual BasicNote : If you do not have the Developer tab.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |