Stop updating links after certain date

[Hoff88]

I have a folder for each month of the year, in each folder is a Workbook for each day of the month. The daily workbooks are all linked to a Master workbook that I use and update certain information everyday. Once a day is past, e.i. Febuary 6th. I do not want that workbook for Feb 6th to update the values from the Master workbook when it is opened.
I know I can easily choose not to update the links when I open it, but the issue is that there are 20+ people that need access to the files and I know someone is going to update the link along the way.

I assume this is accomplished through VBA. Any and all replies are appreciated.

 

[ajetrumpet]

i'm not big into linking workbooks so I can't help you in that regard. however, how are your users updating the links? via pushing a button? selecting an option on the interface menus? if it is the latter, could write VBA code that blocks their effort based on the date that's applicable to the file. if your files are all named in such a way that they are easily identifiable as pertaining to a certain date, then you could actually use the literal file name in your conditional statement where you check for the appropriate date. Sort of like the concept that SEO developers use when they grab the <header> text of a webpage and use its content to create an SEO URL, with hyphens (-) separating the words in the <header> text.

 

[Hoff88]

i'm not big into linking workbooks so I can't help you in that regard. however, how are your users updating the links? via pushing a button? selecting an option on the interface menus? if it is the latter, could write VBA code that blocks their effort based on the date that's applicable to the file. if your files are all named in such a way that they are easily identifiable as pertaining to a certain date, then you could actually use the literal file name in your conditional statement where you check for the appropriate date. Sort of like the concept that SEO developers use when they grab the <header> text of a webpage and use its content to create an SEO URL, with hyphens (-) separating the words in the <header> text.

Upon opening a workbook, you are prompted to answer if you would like to update the links or not. Now this should itself should be enough to prevent updating of the links, but with 20+ people referring to this workbook, someone is bound to update the links and save it. so without selecting a pushing a button or selecting an option on an interface I'm not sure what you're suggesting would work, or maybe I'm not understanding it correctly. And yes, the workbooks will all be named according to the day they are for e.i. Feb 6th, or something of the like, I am open to renaming them to whatever format that would be necessary.

Does anyone know of a way to break a link after a specific date or how to create a button with that will break the link of a specific link in a work book?

 

[ajetrumpet]

do you know how to write VBA code? let me know, and if you don't, I can give you a coding example of what I was talking about earlier.