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
1 lis 2013 · Use the VBA Shell routine (if you must) or ShellExecute from the Windows API (= the better option IMO) to open extracted data. If you are using the newer ACCDB format, then you have the 'attachment' field type available as smk081 suggests.
1 lip 2020 · If a file, maybe you should be using a bound object control. However IIRC that will open the file with its native app, which maybe you don't want. I forget if an unbound object control will do that or not and I can't check right now.
21 kwi 2016 · Have recently upgraded to Access 2016 and find that I can no longer display a PDF file in the web browser control on a form. I used to use VBA to display a particular PDF file stored on my computer...
20 kwi 2022 · From within my Access app, I've been able to open, edit, save and close a pdf file using the Adobe Acrobat reference. The app had been running great for several months. Recently, the VBA "Save" command no longer saves the pdf. .....
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.
20 lip 2017 · 136.6K. Translate. 2 Correct answers. Karl Heinz Kremer • Community Expert , Jul 20, 2017. You need a few more lines. Take a look here for a working example: Adobe Acrobat and VBA - An Introduction - KHKonsulting LLC. Add these lines to the beginning of your program and see if that fixes it: Dim AcroApp As Acrobat.CAcroApp.