Hello Excel Gurus,

I am wondering if there's any alternative to Excel VBA?

The reason why I'm asking this is that I have close to 100 workbooks (they're all of the same layout to the sheet level).

Because the layout are the same, every time there's a modification, I need to apply the changes to all workbooks.

And these workbook have formulas to link to an external workbook - note that external workbook most have the same, but for each workbook, there's at least 5 external wokrbooks that are specific to the respective workbook.

For example say I have a workbook name called 'Canada', and in 'Canada' workbook, there's say about 20 external workbooks to link from (in other words, if I'm in 'Canada' workbook, under Data\Edit Links, I'll see 20 external workbooks). And out of this 20, there's 5 external workbooks that are specifically for 'Canada' only, and won't find in any other workbooks.

In order to apply the changes to other workbooks, Excel VBA is what I used. However, the time to open each individual workbook, enable contents, and do some other changes and close, just takes some time. The longest is actually opening this workbook.

Thus am wondering if there's any other solutions that can enable to have changes to these workbooks way faster.

Was looking at python, but it's a completely new language for me.