open a file if a specific date condition is met

Contributor

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.

 

 

olopa67_0-1646792434014.png

 

the following is the workbook i need to be open to launch the macro UPDATE_INDEX

 

olopa67_2-1646793659382.png

 

thank you for your time which is highly appreciated

0 Replies