Moonscarlet Posted November 14, 2016 Share Posted November 14, 2016 Hello, Is it possible to create a macro and add it to my excel using autoit? Or executing the whole visual basic function itself from the autoit script? Thanks in advance. Link to comment Share on other sites More sharing options...
water Posted November 14, 2016 Share Posted November 14, 2016 Welcome to AutoIt and the forum! To handle general tasks I suggest to use the Excel UDF that comes with AutoIt. I think this subject has been discussed before. Search the forum for VBE as describd here: https://msdn.microsoft.com/en-us/library/ff840360(v=office.14).aspx Use the Run method to execute a VBA macro. https://msdn.microsoft.com/en-us/library/ff197132(v=office.14).aspx 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...
Moonscarlet Posted November 18, 2016 Author Share Posted November 18, 2016 On 11/15/2016 at 0:06 AM, water said: Welcome to AutoIt and the forum! To handle general tasks I suggest to use the Excel UDF that comes with AutoIt. I think this subject has been discussed before. Search the forum for VBE as describd here: https://msdn.microsoft.com/en-us/library/ff840360(v=office.14).aspx Use the Run method to execute a VBA macro. https://msdn.microsoft.com/en-us/library/ff197132(v=office.14).aspx Thanks. 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