[python-win32] excelRTDServer demo not working

Christopher Nilsson chris at slort.org
Fri Mar 14 03:46:16 CET 2008


It's been ages since I looked at this, but you need to make sure the
constants at the top of the module match your version of excel. The
ones that are currently there are for Excel XP (which is the one
before the version you're using, I believe):

EXCEL_TLB_GUID = '{00020813-0000-0000-C000-000000000046}'
EXCEL_TLB_LCID = 0
EXCEL_TLB_MAJOR = 1
EXCEL_TLB_MINOR = 4

There are very likely much nicer, and dynamic, ways to obtain these
values now. I did have   the docs at one stage, but someone else on
the list can probably answer faster than I can find them.

Unfortunately I no longer have a copy of excel to play with.  I
promise it was working with Office XP. :)

Cheers,
Chris.

On 14/03/2008, Kevin O'Connor <kevin at koconnor.net> wrote:
> Hi,
>
>  I've downloaded pywin32-210.zip and installed it on my "Windows XP
>  Professional" machine.  I've been trying to get the demo
>  com/win32com/demos/excelRTDServer.py to work, but have not had
>  success.  I'm using MS Excel 2003.
>
>  When I add a cell in Excel (with
>  =RTD("Python.RTD.TimeServer","","seconds","5")) I get a cryptic "#N/A".
>
>  When I run the excelRTDServer program it states that it has
>  successfully registered.  I can instantiate an object of
>  "Python.RTD.TimeServer" from the win32com ide.  I can register with
>  "--debug" and see trace messages when I instantiate it from win32com
>  ide.  However, when I launch Excel with the above cell formula, I
>  don't see any trace messages at all.
>
>  I have disabled security on macros in Excel.
>
>  Any ideas?  Can anyone confirm if the demo works elsewhere?
>
>  Thanks in advance,
>  -Kevin
>  _______________________________________________
>  python-win32 mailing list
>  python-win32 at python.org
>  http://mail.python.org/mailman/listinfo/python-win32
>


More information about the python-win32 mailing list