Any alternative to Excel VBA

[dluhut]

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.

[Marc L]

Hi !

Whatever by VBA or by Python the time to open the workbook, amend it and save it should be the same !

If you are using Excel as a database software, better is to directly use any real database software …

[Logit]

.
Another thought ... write a macro / s that will automate making the changes to all of your workbooks.

Or ... because you've indicated all the workbooks are identical in layout ... condense all the workbooks into one where is can run a "report" on the data
displaying the various data required. Then save that in a separate workbook for forwarding or archiving if necessary.

[dluhut]

.
Another thought ... write a macro / s that will automate making the changes to all of your workbooks.

Or ... because you've indicated all the workbooks are identical in layout ... condense all the workbooks into one where is can run a "report" on the data
displaying the various data required. Then save that in a separate workbook for forwarding or archiving if necessary.

Yes I did write a macro to automate making the changes to all of the workbooks. But like I said, the time to open up the workbook is the one that causing it to be very slow.

Thus the thread of asking for any other solutions other than VBA

[Logit]

.
Would it be faster (your primary goal) to extract the required data from the 'main workbook' and save that as it's own workbook ? Replacing the previously existing workbook that contained the
old data ?

(Brain storming here ....)