Opening and closing Files within a Macro

[davidbaar]

I have a long macro that adds data to four workbooks and saves the data. It then copies and pastes info within the workbook running the macro, prints two forms, gives the workbook a new file name (save as) and closes the workbook.

I currently have all the workbooks open on my display. Is there a way to open and close each workbook as the macro gets to it?

I run this on Office for Mac, but most sample macros have run okay.