This is difficult to explain but here goes.

I have a macro enabled workbook of my own design which does a specific calculation and then saves the output for that client into a CSV file so that it can be imported back in again at a later date.

The CSV files contain a mix of text and financial figures. I am concerned about the possibility of someone manually editing the cell values in these CSV outputs. Therefore I am after a validation check sum.

This is what I would like: Before saving the CSV file, the XLSM would quickly check the values of all the cells to be saved and use it to create a checksum figure. The figure would be included in the saved CSV in a specific cell (say A1). Upon loading the CSV, the XLSM would repeat the process on the file to be imported and compare it to the value recorded in cell A1 of the CSV to see if it is the same.

I should add that the data saved in the CSV would always be in the same cells (e.g. cell A2 would always be the clients name).

How can I create code to assign a numerical value to each specific cell in the CSV? (And it would need to do it to letters as well).