arrays - How to Loop through multiple workbooks applying the same function to all the workbboks

Question

I need to apply array function using Loop to the multiple workbooks

Scenario:

Workbooks.Open filename:="Core ReportDL tracker Pivot reports Wk10 FY21 - 1.xlsx"
Workbooks.Open filename:="FY21 P01 Apr 2021PL FY2021 Adyen April-20 WK 1 - 1.xlsm"

Workbooks("PL FY2021 Adyen April-20 WK 1 - 1.xlsm").Activate
 
ActiveWorkbook.ChangeLink "Core ReportDL tracker Pivot reports Wk01 FY21.xlsx", _
 "Core ReportDL tracker Pivot reports Wk10 FY21 - 1.xlsx", xlExcelLinks

what is the code to be used by creating (Single dim in array) using loop function. As i have done the linking for Adyen, similaryly i need to do it for15 more customer.

Thanks in advance

question from:https://stackoverflow.com/questions/65933942/how-to-loop-through-multiple-workbooks-applying-the-same-function-to-all-the-wor

Answer 1

Waitting for answers