title: Reading and Writing to an Excel file in Resources
body: <p>I've added my excel file as a resource to my vb project and used the "embedded Resource" option. The name of the file "StoredInformation.xlsx". 
  The 'Build Action' is set to 'Embedded Resource'.</p>
  
  <p>Edit II - However i'm quite stuck again. It seems as if my code doesnt even work when i run my program</p>
  
  <pre><code>Dim sPath As String
  
      sPath = System.IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments))
  
      For i = 1 To 50
          Threading.Thread.Sleep(100)
          Application.DoEvents()
  
      Next
  
      If My.Computer.FileSystem.FileExists(sPath &amp; "\Housing\Stored Information.xlsx") Then
          Dim APP As New Excel.Application
          workbook = APP.Workbooks.Open(sPath &amp; "\Housing\Stored Information.xlsx")
          worksheet = workbook.Worksheets("Sheet1")
          APP.Visible = False
          MessageBox.Show("File Opened!" &amp; Environment.NewLine &amp; "Path: " &amp; sPath &amp; "\Housing\Stored Information.xlsx")
      Else
          My.Computer.FileSystem.WriteAllBytes(sPath &amp; "\Housing\Stored Information.xlsx", My.Resources.StoredInformation, True)
          Dim APP As New Excel.Application
          workbook = APP.Workbooks.Open(sPath &amp; "\Housing\Stored Information.xlsx")
          worksheet = workbook.Worksheets("Sheet1")
          APP.Visible = False
          MessageBox.Show("File Created!" &amp; Environment.NewLine &amp; "Path: " &amp; sPath &amp; "\Housing\Stored Information.xlsx")
      End If
  </code></pre>
  
  <p>It's not creating my folder "Housing" or my file "Stored Information.xlsx"
  Could someone please take a look and tell me what im doing wrong?</p>
  
  <p>Edit - I found out that it can't create the new dir because of the protection level, so when i changed the destination to the desktop it created the excel file, but it needed to be repaired.</p>
  
  <p>Can someone tell me how to created a new folder and add a file without damaging the excel file?</p>
  
  <p>Edit - Made changes to the code, it's still not creating the new folder in My Documents and add the file "Stored Information.xlsx"</p>