[Tim Golden] > + When trying to automate anything in Excel, it's > usually illuminating to record a macro which does > what you want, and then to translate that VBA code > into Python. >
[Duncan Booth] > Another suggestion: when automating Excel, turn off the automatic > recalculation (set Application.Calculation=xlManual) and then turn it back > on again when you have finished. > If you don't do this, Excel will attempt to recalculate the sheet after > every update to a cell. Even if you don't have any formulae referencing the > cells you change it still makes a big difference. Thanks. Didn't know that. TJG ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- http://mail.python.org/mailman/listinfo/python-list
