What methods are available to encrypt/scramble some exported data I have from Excel? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
I need to be able to allow the user to do a custom export (not regular SaveAs) of a fixed set of variables (over 500) from a spreadsheet. The export function I'll design but I'm wondering how to write the data such that it's not easily editable by the end user (no text editable files so that I don't have to worry about validating the data when it's imported). There could be multiple instances of these exported data files.
I'll then write my own custom import function to prompt the user to identify which data file to be imported and then descramble the data and re-apply it to the specified cells in the workbook.
The answer is probably some Win32 calls, eh? I've only done trivial Win32 API calls before so if that's the answer, please direct me to some sources where I can learn more details.
So why do all this import/export? Because we don't want the usrs to have to keeping doing 'SaveAs' and creating 40MB .xls files for each data set they want to keep.
Thnx, Deb <img src=/S/newbrain.gif border=0 alt=newbrain width=21 height=22>