title: Opening Excel Workbooks with default Credentials on Sharepoint server
body: <p>I'm looking into extending some code that handles automatic opening and reading of Excel files. Ultimately this process needs to be able to run on a server so there is a strict requirement of no dialogs/user interactions required.</p>
  
  <p>Currently this is all working fine for normal files, but now I need to be able to extend this functionality to access files on remote machines such as SharePoint/WebDAV systems.</p>
  
  <p>The problem I've got at the moment in my little test application, is that as soon as I call the Open on an Excel Workbook I get a prompt asking me for my windows credentials. Now I can provide them, or click cancel (I'm assuming this defaults to current user credentials) and the file opens without problem.</p>
  
  <p>What I need to do however, is find a way to access this file without the prompt...</p>
  
  <p>Does anyone have any ideas on how to do this? </p>