Search results
2 maj 2017 · Yes, you can use the Shell object to run the file. ' Use Windows shell to run file. Sub WinRun() Dim shell As Object Set shell = CreateObject("WScript.Shell") shell.Run "Your-Drive:\Your-Path\Your-File.pdf" End Sub
29 lis 2019 · I'm trying to open all appropriate PDFs found in the same directory as my Excel workbook using VBA. I've added the Adobe Acrobat xx.x Type Library reference to the project. But when I try to create the .App object I get a "Run-time error '429':" error.
28 lip 2023 · You can use the FollowHyperlink method in VBA to open a PDF file from a specific file path. Here is one common way to use this method in practice: Sub OpenPDF() ActiveWorkbook.FollowHyperlink "C:\Users\bob\Documents\basketball_data.pdf" End Sub.
9 sie 2010 · I have a Command Button (Command10) that I am trying to use to open a PDF drawing with a file name that matches the part number. (The PDF’s have file names the same as the Part Numbers). The code I have been trying is:
12 gru 2005 · You can use the OpenFile option of the ShellExecute() method. My sample shows how to open any registered file for the users PC. Browse [Find a directory or file]
I am trying to open a PDF from a button on a subform. The location of the PDF is specified in a field. I want to open the PDF and search for a Member ID criteria also listed in a field on the Form.
29 kwi 2013 · Check the file path and if is valid, use the FollowHyperlink method in order to open the PDF file. With the FindWindow API function find the window of Adobe Reader or Adobe Professional that contains the opened PDF file and bring it to foreground using the SetForegroundWindow API function.
