NOTE: I have not implemented encryption on Excel 64 bit yet. I did cover Cookies and Excel in other articles, but in this case I decided to go with Kyle’s approach and use the registry, but this time I store and encrypt all the information needed to access and refresh authentication after one initial usage. Web applications can use cookies, and have control over return URLS. There are a few challenges implementing this in VBA, as hiding the required refresh tokens, client secrets and even receiving the access code through a dummy redirect URL is quite complex. If this is successful the new access token can now be used, with later refreshes repeated when it expires. In this case, the app requests a new access token by sending the refresh token, along with some client secret data, to the refresh URL.
0 Comments
Leave a Reply. |