Re:Automating Microsoft Office with Python
by pge on Monday September 02, 2013 @03:08PM
(#6316596)
One of the first things i learned about writing VBA macros was to start every one with application.screenupdating = false. It was amazing how much of a performance hit the screen updating was.
[ Parent
| on HN ]
Re:Automating Microsoft Office with Python
by agumonkey on Monday September 02, 2013 @04:48PM
(#6317122)
I remember at least three "mandatory" statement to wrap any heavy script. Actually I don't remember them, just some fuzzy count.
ps: I don't know how Excel is structured these days but up until 2003 there was zero multicore code, and VBA is not the fastest system around, so any way you can trim the workload is good.