I have made nice macro that will send login details to API which will return as response security string that is used for sending further commands to API and executing them. I am a bit worried about lack of security as I guess storing password and API ID in plain code is not secure. Therefore I made msgbox where user enters numeric value. The API ID code is then simply divided by this number so if somebody will get accidentally in possession of spreadsheet, wont be that easily able to figure out API ID.
I would like to do something similar with password. However that is string and case sensitive - something like "KIffOIKWXYEcgU" How can I implement such easy was of encoding for string of text?
Thanks a lot !
