<div>
Why are you closing and reopening the workbook? There may be alternatives to eliminate this requirement.
</div>

<div>
because I need update the data in one workbook, then save it then access the saved data. &nbsp;When I tried to use active worksheet. &nbsp;the data was not copied into the master template, but if I reran the code the saved file was able to update the master template. &nbsp;So this was my workaround, and I got it work acceptably. 
 

<pre><code class="code-10 nolinks" id="code-20-41512722-1"> If ShName = &quot;ResPlan_Data&quot; Then
 Call UnpivotResPlan
 myBook.Close savechanges:=True
 Set myBook = Workbooks.Open(MyPath &amp; MyFiles(FNum), UpdateLinks:=0)
 Set ws = myBook.Worksheets(ShName)
 End If
 
 '**************************************************
 'Updates template data per shName
 '*************************************************
 If Not ws Is Nothing Then
 Set BaseWks = wbMaster.Worksheets(ShName)
 Set sourceRange = ws.UsedRange
 'Exclude header labels
 Set rng = sourceRange.Offset(1, 0).Resize(sourceRange.Rows.Count - 1, sourceRange.Columns.Count)
 
 RwCount = rng.Rows.Count
 rnum = BaseWks.Cells(BaseWks.Rows.Count, 1).End(xlUp).Row + 1
 
 BaseWks.Cells(rnum, &quot;A&quot;).Resize(RwCount).Value _
 = myBook.Name
 BaseWks.Cells(rnum, &quot;B&quot;).Resize(RwCount, rng.Columns.Count).Value = rng.Value
 End If
 With wbMaster.Worksheets(ShName).ListObjects(1)
 On Error Resume Next
 .DataBodyRange.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
 On Error GoTo 0
 End With
 
 Next ShName
</code></pre>
</div>

<div>
<div class="content wysiwyg-content">
need help with the correct syntax based on the code sample. &nbsp;I need to close then reopen a workbook after it has been saved. &nbsp;what is the proper syntax? 
 

<pre><code class="code-10 nolinks" id="code-10-28933932-1"> Set myBook = Nothing
 On Error Resume Next
 Set myBook = Workbooks.Open(MyPath &amp; MyFiles(FNum), UpdateLinks:=0)

 If ShName = &quot;ResPlan_Data&quot; Then
 Call UnpivotResPlan
 myBook.Save
 myBook.Close
 mybook.????

 End If
 
</code></pre>
</div>
</div>

need help with the correct syntax based on the code sample.  I need to close then reopen a workbook after it has been saved.  what is the proper syntax?

(CODE)

open excel workbook vba

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.