I'm self-learning XL(97) and this board has been tremendous. But ... I've now been given the on-going job of reviewing data from the past 4 years to find changes. Currently, I'm doing the process "manually" : re-format the current report; running each of 8 reports against it; filtering out the changes in each.
Can VBE "automate" the steps? (Reformat the current report, compare it to the 8 previous reports, etc) If so, any recommendations as to a good beginners book?
Does VBE for XL97 have to be re-learned if we upgrade to XL2M or XP?
Thank you all for your continuing participation in this board. Although I don't always understand the answers, I appreciate the caring and sharing.
Can VBE "automate" the steps? (Reformat the current report, compare it to the 8 previous reports, etc) If so, any recommendations as to a good beginners book?
Does VBE for XL97 have to be re-learned if we upgrade to XL2M or XP?
Thank you all for your continuing participation in this board. Although I don't always understand the answers, I appreciate the caring and sharing.