I’m helping a fellow worker automate the running of a bunch of macros in a bunch of workbooks. I’m writing a VBScript that will open a series of Excel workbooks and run a macro in each of the workbooks. The VBScript will read a CSV file that contains a list of workbooks and the macros to run in those workbooks. I’d like to make the script robust enough to skip running a macro that doesn’t exist.(i.e. maybe my fellow worker fat fingered the macro name or forgot to write a macro for that paticular workbook). Is there a way to check to see if the macro exists before running it, or do I just need to trap the error and move on?
