VBA Macro to open / close multiple Workbooks

[Odracir]

Good night,

I was wondering if there's a way to make a VBA macro to open some workbooks in a certain directory (the same where the workbook with the macro will be) in some user defined order. Lets make an example:

MacroWorkbook.xlsx

WorkbookDataCollection.xlsx

Temperature1.xlsx | Temperature2.xlsx .... TemperatureN.xlsx
Flow1.xlsx | Flow2.xlsx .... FlowN.xlsx

I have WorkbookDataCollection.xlsx collecting all data from the different Temperature and Flow data sheets, but since it only collect if they are opened I need a macro to open them all (The N stands for different amount of data workbooks) and after they are all opened to close them.. Lets say I have two of each, the process will be:

OPEN:
Temperature1.xlsx | Temperature2.xlsx | Flow1.xlsx | Flow2.xlsx -----> WorkbookDataCollection.xlsx

CLOSE:
Temperature1.xlsx | Temperature2.xlsx | Flow1.xlsx | Flow2.xlsx | WorkbookDataCollection.xlsx

Given there are random number of data workbooks, I think I would need some sort of loop.

Thanks in advance
Odracir

[buran]

Hi,

something like this

Please Login or Register  to view this content.