A python process which uses pyTTS will block any Excel
which uses DDE Links.
To reproduce this, run python and the following
commands:
import pyTTS
o=pyTTS.pyTTS()
then, as long as this python process is running, Excel
cannot open a DDE Link; it just freezes until the python
process is terminated.
To reproduce this, one can use Excel as both DDE client
and server by opening two Excel processes:
The server Excel opens a workbook called e.g.
TestSource.xls which contains some data in cell A1 of
sheet "Sheet1".
The client Excel tries to open a workook which contains
the following formula (DDE link to cell A1):
=EXCEL|[TestSource.xls]Sheet1!'R1C1'
Any help in identifying the cause of this is greatly
appreciated.
Kind Regards
Andreas Kessler
andi_kessler_1@hotmail.ch
Logged In: YES
user_id=624776
My guess is that the problem is in the Python win32com
package and not specifically in pyTTS. All pyTTS has done in
the two lines:
import pyTTS()
tts = pyTTS.pyTTS()
is dispatched a COM client using the Python win32com package.
Does this same problem happen when another Python COM client
is running? Or is it specifically related to pyTTS?