Search results
9 wrz 2021 · I'd like to open a specific PDF based on the file path in another sheet "Paths" cell C2, when I click a button (in another sheet) with a macro assigned. I've just started learning vba last month so far I have this but I encounter an error - Sub Sample() ActiveWorkbook.FollowHyperlink Sheets("Paths").Range("C2") End Sub The error is:
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.
17 gru 2011 · If you want it to automatically trigger on change, you will need to build a selection change macro in the worksheet object. I suggest using a switch case statement to choose which PDF to open, based on the value it finds in the target cell.
In cell A1 of my excel I have the path of where the pdf version of the file is located plus the file name, e.g. "C:\Local Files\Tester\MNBU 123456.7. Since the files that I want to open through a macro button will always be PDFs, I'm guessing that I have at least 2 options: 1. Write ".pdf" in cell B1 and then in C1 I do the formula =CONCATENATE ...
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.
4 gru 2016 · How can I open the pdf file if the pdf file name started with cell K3 value? VBA Code: Sub OpenPDF() ' Declare variables Dim filePath As String Dim cellValue As String ' Get the value of the cell . cellValue = Range("K3").Value. . ' Specify the folder path .
13 sty 2016 · Open a pdf file based on a cell's value. Hi All, I have a spreadsheet that imports a number using a formula. I am trying to have that number open a .pdf file in a predefined folder automatically and display it.
