[python-win32] Excel to python COM not working. Please help!

[Tim Roberts]

Tarun Kapoor wrote:
> I am supporting this old legacy code that someone else wrote. A user
> had their computer replaced and the code stopped working. We have some
> code written in python that we want to access from Excel. We register
> the python COM like shown below
> ...
> Just for the sake of testing, I have these 2 lines of code behind a
> button in Excel
>
> Dim dbServer As Variant
> Set dbServer = CreateObject("WSdbAccess")
>
> And i get the error ""The specified module could not be found" on the
> second line of the code. It does work from all other computers. The
> environment is Windows 7 64 bit computers with 32 bit excel and 32 bit
> python 2.7. I have opened the registry and WSdbAccess does exist. I
> have compared the registry of the new computer with the old computers
> and its the same..

Where did you look in the registry?  Remember that, on a 64-bit system,
32-bit components get registered in HKEY_CLASSES_ROOT\Wow6432Node\CLSID,
not in HKEY_CLASSES_ROOT\CLSID.

-- 
Tim Roberts, timr at probo.com
Providenza & Boekelheide, Inc.