Hiding an SQL connection string in an Excel macro

Is there a technique for hiding the SQL connection string (ADO) in an Excel
macro? I think I already know the answer to that question (no), but I'm
just wondering if there's a trick that would accomplish it.
I'm authoring some macros for a client of mine and they need to communicate
with an SQL server account I have with my web hosting company and I
obviously don't want them to know my username and password.
Thanks in advance.
Hi Bob,
From your descriptions, I understood that you would like to "hide" SQL
Connection Strings in your macro to protect your SQL username and password.
Have I understood you? Correct me if I was wrong.
Based on my scope, yes, we are not able to "hide" SQL connection strings
directly, however, I think you could encrypt your macro as a workaround.
You can password protect the VBProject. In VBA, go to the Tools menu,
choose VBA Project Properties, then the Protection tab. There, check the
"Lock Project For Viewing" tab, and assign a password. Note, however, that
there are products available that can defeat the password protection. In
this way, you are able to protect your SQL username and password.
For more information about how to do this in encrypt this in Excel, I would
appreciated if you could create a new thread in the
microsoft.public.excel.programming (BTW, I am not sure whether it is a
managed newsgroup)
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!