Thank you for reading my post
I need a macro that open all the files in column D if the costing date is older then 30days, i would like also that after the file is open to run a macro called UPDATE_INDEX which is saved in the just opened workbook and then close it.
if it is possible override all the warning and error messages popping up when for example i manually open the files, all messages are manly regarding updating links etc.
the following is the workbook i need to be open to launch the macro UPDATE_INDEX
thank you for your time which is highly appreciated