LeanneGodney
Technical User
Hi there,
I have an application of hundreds of Excel macro files that all reference one central excel file. This central excel file acts like an add-in.
If I make changes to this main file it could have knock on effects on the individual macros using it.
I would like to be able to run some code that opens up each of the individual macros and runs a compile on it. If it compiles, great, if not, I'd like it to flat that file to me.
I know how to do everything other than to get it to compile. Manually, from the VBA screen you click Debug --> Compile. This is all good, but I don't want to have to manually dot his for 100's of files!
Any help would be most appreciated. Thanks!
Leanne
I have an application of hundreds of Excel macro files that all reference one central excel file. This central excel file acts like an add-in.
If I make changes to this main file it could have knock on effects on the individual macros using it.
I would like to be able to run some code that opens up each of the individual macros and runs a compile on it. If it compiles, great, if not, I'd like it to flat that file to me.
I know how to do everything other than to get it to compile. Manually, from the VBA screen you click Debug --> Compile. This is all good, but I don't want to have to manually dot his for 100's of files!
Any help would be most appreciated. Thanks!
Leanne