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?
Set myBook = Nothing On Error Resume Next Set myBook = Workbooks.Open(MyPath & MyFiles(FNum), UpdateLinks:=0) If ShName = "ResPlan_Data" Then Call UnpivotResPlan myBook.Save myBook.Close mybook.???? End If