Check if Other Workbooks have been changed and SHEETS within

  • Hi All,


    My boss has asked me to create some code to check if some workbooks have been updated (not too hard). But he's also asked me to check if the sheets within those workbooks have been changed (this I don't know).


    The code I have written so far



    So my code to check workbooks is easily done.


    I've setup the structure for opening the workbooks, and I've setup looping between the sheets in the workbook. But I'm lost on what to do from there ('needs something here to check if sheet has been changed since last login).


    Maybe I don't even need to open the workbooks?


    I have a quick easy solution in my mind, which is to have a close and save date in each sheet from those foreign workbooks. Then my code just needs to find that date and grab it.


    But perhaps there is an easier way?


    Thanks all

  • Re: Check if Other Workbooks have been changed and SHEETS within


    Hello,


    Why don't you turn on the history to Track Changes ...?


    see https://www.gcflearnfree.org/excel2016/track-changes-and-comments/1/


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!