Is there any way to automatically use the NT ID / Pasword in a VBA Procedure?

[Sthrncali]

I don't want to see them myself or assign them to variables... I have a connection string thats fetching data from a Remedy Server and in the connection string in VBA I can assign the UserID / Password within the connection string...

However its several users that would be using the file so I was hoping there maye be an API call or something like that that will automatically supply the current users Username / Password to the server I am logging into?

I know like when I am logging into my SQL server using MS SQL Studio 2005 there is a checkbox for "Use NT Credentials" so I don't have to manually type in my User/PW.

 

[Hermanito]

The current username you can get with this:

Dim Username as String
UserName = Environ("USERNAME")

You can get many other useful properties this way, searching via Google will get you a list somewhere, but the password is not one of them (obviously). If the connection you talk about needs the current user's credentials, have you tried by not supplying them at all? Maybe the connection then defaults to the user's credentials without you needing to supply them, because Windows takes care of that behind the screens (might be wishful thinking here, not sure).

 

[bensonsearch]

Hi,

As far as i know only the username, windows has denied access to the password.