title: save and close a workbook with its existing name and reopen it with VBA
body: <p>I have my VBA code below, I would like that my macro saves and closes on mydesktop my activework with its existing name, then I would like that my macro reopens it. When I execute my macro, it saves and closes my activeworkbook with its existing name on my desktop but it does not reopen the excel file. It seems that the part of the code <code>Workbooks.Open ("\\C:\users\ing\users3\Xavi\Desktop\" &amp; ActiveWorkbook.Name)</code> does not work in my macro.</p>
  
  <p>If someone know the solution, that would be great.
  Many thanks
  Xavi</p>
  
  <pre><code>Sub openandsaveactiveworkbookandreopenit ()
  Dim myactiveworkbook As Workbook
  Set myactiveworkbook = ActiveWorkbook
  ActiveWorkbook.SaveAs FileName:="\\xxxyyyy\users\ing\users3\Xavi\Desktop\" &amp; ActiveWorkbook.Name _
   , FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
  
  ActiveWorkbook.Close
  
  Workbooks.Open ("\\xxxyyyy\users\ing\users3\Xavi\Desktop\" &amp; ActiveWorkbook.Name)
  
   End Sub
  </code></pre>