View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Smith[_2_] Bob Smith[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.