Saving a WB to Sharepoint

[fb7894]

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?

Thanks

[Oorang]

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).

[fb7894]

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.