ExcelBanter - Hiding SQL Connection String

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hiding SQL Connection String (https://www.excelbanter.com/excel-programming/355781-hiding-sql-connection-string.html)

Hiran de Silva[_2_]

Hiding SQL Connection String

What is the best way to hide a connection string in an Excel application ?

(1) Protect VBA Project - but it can be hacked.
(2) put connection string in an Add-In - but (1) still applies.

Any bright ideas?
BTW I have an ASP.NET version of the same app but I would like to distribute
the Excel version also.

Thanks,
Hiran

All times are GMT +1. The time now is 01:32 PM.