3 ms·
Not saying that I don't believe you, but I've never seen a VBA code that executes longer than 1-2 minutes. What exactly does one do that takes so long?
by Bishonen88 9y ago
Not saying that I don't believe you, but I've never seen a VBA code that executes longer than 1-2 minutes. What exactly does one do that takes so long?
- orwin 9y agocopy the spreadsheet, modify some code because the need is sightly different (or the spreadsheet need adjustment) and voila. Either it works just fine on the first time, either you just begun a one hour debugging session. To me excel is just fine, except when its not. A French bank lost 6 billion ten years ago because one market maker made false entry on a spreadsheat and no one in the back office noticed for more than 2 years. And the back office was not at fault here.
- bkor 9y agoe.g. when reading in data one cell at a time instead of reading in a range at once. Basically inefficient programming. It's probably not that much about Python vs Excel but more difference in knowledge/expertise/capabilities.