-
Saving a WB to Sharepoint
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.
[vba]
myWB.SaveAs ("http://xxx-sharepoint.net/myWB.xls")
[/vba]
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
-
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.
Cordially,
Aaron
Keep Our Board Clean! - Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules