fb7894
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?
Thanks
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