gripper Posted October 10, 2012 Share Posted October 10, 2012 I have an Access DB. I have a command button on a form that I wish to click and have it run an autoit script I created that is on my desktop. The script works fine when I actually click on it but I cannot figure out how to use a command button in Access to run that script. I get errors. Here is what I have at this point Private Sub Open_Web_Click() Application.Run ("C:\Users\user1\Desktop\E-O.au3") End Sub I have tried execute command as well and it is dead. Again my autoit script works perfectly. I am just trying to get it to work from a command button in VBA (MS Access) I would appreciate any help in resolving my syntax issues. Thanks Link to comment Share on other sites More sharing options...
water Posted October 10, 2012 Share Posted October 10, 2012 Try this: Compile the script to an exe using SciTe (F7) and run the .exe from VBA and not the .au3 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now