Hi Tim, Thanks so much!
Is there anything like a "global" Worksheet_Calculate, which would get hit when the entire worksheet calculation is done? Also, are there many event sync examples in Python? Many thanks! Paul -----Original Message----- From: python-win32-bounces+paul.bilokon=citi....@python.org [mailto:python-win32-bounces+paul.bilokon=citi....@python.org] On Behalf Of Tim Roberts Sent: 25 August 2009 18:13 To: Python-Win32 List Subject: Re: [python-win32] Excel Calculation - Check when it's done Bilokon, Paul wrote: > > My apologies as this question is indeed Excel specific though it's > wide applicability probably merits inclusion here. > > Is there any way to determine when a calculation is done in Excel from > Python over COM, without busy-waiting? > > Does anyone have any examples? Assuming you can register yourself as an event sink, there is a Worksheet_Calculate event that gets fired any time Excel recalculates a cell. However, it gets hit an awful lot. -- Tim Roberts, t...@probo.com Providenza & Boekelheide, Inc. _______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32 _______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32