How can I make a VBA macro 100 times faster?

Question

My boss wants me to create an application in VB6 or VBA that will mimic a process that is currently done on a mainframe computer. I got it to work, but it is way too slow. I'm very sure it isn't a matter of performance tuning the code, but rather the fact that we are trying to run it on a PC. Is there any way with a PC and VBA/VB6 that I can improve performance by 100+ times?

Answer 1

Make sure each macro/VB6 SUB or FUNCTION only performs a SINGLE TASK. If multiple tasks need to be performed in a particular sequence, you can CALL Task2() from inside Task1().

Answer 2

Without having slightest idea what your code is doing, I have a general suggestion that might improve the code:

Write your most time consuming piece of code in C++ and make a .dll that can be called from VBA or VB6. Perhaps a combination of windows APIs may be helpful too.

Answer 3

if what you asked is possible, nobody will buy a mainframe and IBM will be bankrupt now!