Activate next workbook

[Mladen82]

Hi all,

Every day I export 4 workbooks from Navision. I would like to create a macro that will put all 4 workbooks into one and then do some calculations. The problem is that these workbooks have different names every day. Is there a way to activate the next workbook regardless of the name?

[NeedForExcel]

You can put them into 1 single folder, and maybe loop through all the workbooks in that folder.

[HaHoBe]

Hi, Mladen82,

putting them into a directly and use Dir() and a For Each ... Next-loop would let you do most anything including putting them together.

Ciao,
Holger