A little history. I wanted to use a company's sharepoint site to host the update files for a program I had written for them. So I was looking for a way for my program to login and check for an update. The isue was that some of the employees didn't have a sharepoint account. I also wasn't able to successfully loging with a generic account thru VBA. So I hired a company thru guru. They were able to create a workaround for me. Gave me code and instructions on how to install it on the (Update) folder sharepoint site. I then added vba code to my program that would authenticate to the folder. The installed software would then send (Download) the file you requested.
So No I was not able to uathenticate as a user, but I was able to accomplish a work around.
Adolph