Thread: Encryption
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lydon Bergin Lydon Bergin is offline
external usenet poster
 
Posts: 6
Default Encryption

Hello All:

I am working on an Excel workbook with VBA that will be used to print
temporary checks for our customers. I have everything working great, but I
want to be able to save the customer information each time a new customer is
entered for future reference. To do this, I would need to save names,
addresses, and account numbers somewhere, but of course security is my first
issue. How should I go about doing this?

I have worked with a couple of encryption modules, but they encrypt a string
to (what I assume is) an array of bytes that I can't get into a cell (well,
I can but it shows up as Chinese). What I really need is something that
will encrypt a string to another string, but 1, are there any modules that
do that, and 2, is that secure enough? How can I save these byte values
somewhere that I can get them back? Any help would be greatly appreciated.

Lydon D. Bergin
MCP, MOS