Avatar of Karen Schaefer
Karen Schaefer
Flag for United States of America

asked on 

open excel workbook vba

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

                     End If

Open in new window

Microsoft ExcelVBA

Avatar of undefined
Last Comment
Roy Cox

8/22/2022 - Mon