Excel VBA code: Workbook to Array The VBA Arrays are a very effective way to work with data in Excel. The Array is a…