Excel Macros Automation using Python and AppleScript

Problem Statement: Running the same Macros on thousands of different files can really be a frustrating job. Here is a sample bot which tries to ease the task. Double-clicking the bot icon activates the bot. The bot : Uses Python and AppleScript to open the Macro file (Macro.xlms) and the XLSX file (on which the macro needs to be run). Types in the Macro name to search the macro in the Excel file. After searching, clicks on the result to run the macro on the Excel sheet. Clicks on 'Run' Runs the Macro on the Excel sheet with the data. The video: 1. Shows the Macro File. 2. Shows the Data XLSX file. 3. Shows closing of both the files so that the bot could be run now. 4. Double-clicking the bot icon activates the bot. 5. The bot searches for the Macro amongst the list of macros. 6. On finding, it runs the Macro on the data file.