Solved

# Excel VBA Hash of All Formulas and VBA

Posted on 2011-03-01

I have a bunch of Excel files with formulas and VBA scripts. I do not mind if the values in the spreadsheets are different, but I want to make sure that all of the formulas and VBA scripts are identical. Is there a way in VBA that I can compute a hash of all the workbook formulas and scripts? That way, if the hash of the different workbooks are the same, I know that all of the calculation steps are the same, even if the values are different. Thanks.