Hi
I have a macro that create 12 files from a template using the command:-
I am trying to use the following VBA to open all 12 files, however it only opens the Last file and the first file. I understand the last file as there is no 'ActiveWorkbook.Close once 12 December has been saved.
Please note Path is defined in the macro with the following command Path = ThisWorkbook.Path & "\"
Is it possible once all the files have been created that I can use VBA to open them all up?
I have a macro that create 12 files from a template using the command:-
Rich (BB code):
ActiveWorkbook.SaveAs Filename:=Path & "01 January.xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled
ActiveWorkbook.SaveAs Filename:=Path & "02 February.xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled
ActiveWorkbook.SaveAs Filename:=Path & "03 March.xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled
Etc. etc. etc.
ActiveWorkbook.SaveAs Filename:=Path & "12 December.xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled
I am trying to use the following VBA to open all 12 files, however it only opens the Last file and the first file. I understand the last file as there is no 'ActiveWorkbook.Close once 12 December has been saved.
Rich (BB code):
Workbooks.Open Path & "01 January.xlsm"
Workbooks.Open Path & "02 February.xlsm"
Workbooks.Open Path & "03 March.xlsm"
Workbooks.Open Path & "04 April.xlsm"
etc etc etc
Please note Path is defined in the macro with the following command Path = ThisWorkbook.Path & "\"
Is it possible once all the files have been created that I can use VBA to open them all up?