Launching Python Scripts from Microsoft Access / VBA

In this video, we're going to look at calling another program from Microsoft Access, specifically a Python script. While the Visual Basic for Applications language is very versatile and powerful, there are some modern applications that a language Python is simply more suited to. The good news is that you can use Access and Python together to get the job done. Just for this demo, I'm building a script launcher interface with Access although, in most cases, you might choose to run a single Python script from somewhere in your VBA code. If you don't work with Access much, this will also show you some of its abilities. This demo is also a good look at debugging in VBA and other part of Access design. Chapters: 0:00 - Creating an Access database application. 3:16 - FileDialog control 5:22 - Microsoft Scripting Runtime for File I/O 8:10 - VBA Shell function 12:55 - Linking to a text file in Microsoft Access The Python Script and Access app for this video are available through my Github repository. https://github.com/ajcomeau/PythonScripts Using the FileDialog object from Microsoft Access VBA https://learn.microsoft.com/en-us/office/vba/api/access.application.filedialog Access VBA Shell function https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/shell-function Determining when a shelled process ends in Access VBA https://learn.microsoft.com/en-us/office/vba/access/concepts/windows-api/determine-when-a-shelled-process-ends If you would like to see more of my work, please check out my site at https://www.comeausoftware.com. Narration produced with ElevenLabs text-to-voice. https://try.elevenlabs.io/cstts This video was produced on the Kamrui Essenx E1 mini PC. Available on Amazon - https://amzn.to/3GwlUt9. See my full review here on YouTube - https://youtu.be/p9tsDmaWFqQ If you find this video helpful, please take a moment to Like and Subscribe! Creative Commons music by Jason Shaw on Audionautix.com. Video title card auto-generated with Canva.com. #MicrosoftAccess #Python #Scripting #VBA #Shell