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 <[EMAIL PROTECTED]> 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@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
