title: Save as an Excel file embedded in another Excel file
body: <p>I want to manage with VBA an Excel file embedded in another Excel file. I can find many results with .docx documents, but I stuck with a .xlsx one.</p>
  
  <p>My last try is using OLE objects, but stuck at the line "SaveAs" (Error 1004).
  Here is the weird part: when I start debugging, or if I run the program step by step using F8, it did run, but no file were saved... </p>
  
  <p>I called my OLEObject "TEST" for this example:</p>
  
  <pre><code>Sub testOLE()
  mPath = ActiveWorkbook.Path
  
  For Each obj In Worksheets(1).OLEObjects
   If obj.Name = "TEST" Then
   obj.Verb
   obj.Object.Activate
   obj.Object.SaveAs mPath &amp; "TEST_success.xlsx"
   obj.Object.Close
  End If
   i = i + 1
  Next
  End Sub
  </code></pre>
  
  <p>I don't understand how to save OLEObjects as .xlsx, could you help me a bit?</p>