open a file if a specific date condition is met


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

0 Replies