views:

159

answers:

0

I'm trying to open a workbook from within Excel. The Excel file is located on a SharePoint server, within a Document Library.

I use the following code to open the workbook.

newWorkbook = globalsThisAddInApplication.Workbooks.Open(
                            workbookUrl, Type.Missing, false,
                            Type.Missing, Type.Missing, Type.Missing,
                            Type.Missing, Type.Missing, Type.Missing,
                            Type.Missing, Type.Missing, Type.Missing,
                            Type.Missing, Type.Missing, Type.Missing);

When I do this the user has to enter his credentials (username/password dialog). I'm already storing the user credentials, and I want them to be used when the file is opened.

So how do I pass the credentials to SharePoint?