Open Multiple excel files using VBA

[Kayslover]

Hi

I have a macro that create 12 files from a template using the command:-

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.

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?

 

[JLGWhiz]

JLGWhiz,

I will do some research on the Internet for #8, and will raise a thread.

Thank you for your assistance.

You're welcome,
Regards, JLG