View Full Version : Saving a WB to Sharepoint

06-24-2009, 07:57 AM
I'm creating an app where the user can press a button to automatically upload a Workbook to a Sharepoint server. To do this, I'm using the WB.SaveAS function.

myWB.SaveAs ("http://xxx-sharepoint.net/myWB.xls")

My problem is that the user is prompted for their Sharepoint username and password everytime.

Is there a way to program the username/password into the VBA?


06-26-2009, 11:06 PM
WSS uses NT Authentication. You could do a few hinky things to automate the entry (see also: "bad practice") but you really shouldn't for reasons discussed here (http://www.vbaexpress.com/forum/showpost.php?p=188115&postcount=4).

06-27-2009, 07:25 AM
Thanks for the reply Oorang. Could you elaborate on the "hinky things"?

We are using Sharepoint as nothing more than a centralized place to store files (no different than a network drive). Security is not issues.

Thanks so much for your help.