Search results
To use less code as possible you can Just run this PowerShell one-liner in VBA: $downloadsFolder = (New-Object -ComObject Shell.Application).NameSpace('shell:Downloads').Self.Path. For how to run the .ps1 see here. You can also embed the one liner (But that's a new topic).
24 lis 2001 · How to write API function declarations compatible to the old 6.0 version of VBA (Office 2000 to 2007) as well as the new 7.0 VBA version (Office 2010 onward) with the API declarations supporting 64bit as well as 32bit. To try-out/use the code … Download the ZIP and extract the file.
27 kwi 2011 · Fortunately, you can now use the built-in PDF export capabilities of Access. Here's an example: I believe this works in Access 2007 and up; it definitely works with Access 2013. Here's a link to an MSDN forum post with more information. Install a PDF print driver and use it to print out your sheet. For example, I have PDFCreator installed.
If all you want to do is save the file under a different name, it can be done more simply. You can use the FileCopy command to make a copy of a file and rename it at the same time. This previous answer has an example of how to do that.
Use Word to open a file and then save it as PDF using VBA. Run in any Office application such as Access, Excel, PowerPoint, Visio, Project, ... or from Word on the active document using the special version starting with "RunFromWord".
23 paź 2018 · We have a shared access database where one user had their Adobe Acrobat Reader DC updated to the newest 2018-2019 version. Everyone on the team (that has a 2017 adobe acrobat version) can export the report to pdf using the code below with no problem, but the user who has the latest Acrobat Reader, gets the runtime 2501 error (output to action ...
Open the VBA editor in a number of different ways. Identify the code window, project explorer and immediate window. Select different forms and reports from the project explorer. Select and rename modules. Use basic tools for writing code. Understand the “DoCmd” object. Convert Macros to VBA code.
