Problem with ImprocServer32

[DominikRoB]

I encountered the same problem as described here : #1569
I registered a Python Class to be used via VBA and COM but could not create it. (Error: Module not found).

• Expected behavior and actual behavior.
  I expected that I could register the COM Object from python and use it in VBA, but I had to rename InprocServer32 to InprocServer before it worked.

• Steps to reproduce the problem.
  I used the code found here: https://stackoverflow.com/questions/45410316/is-there-a-way-to-call-a-python-code-in-excel-vba/53982571#53982571 (Only changed the GUID)

Additionally, I tried to create the COM object from within Python, which worked flawlessly:

from comtypes.client import CreateObject
c = CreateObject('SciPyInVBA.PythonSkewedNormal')
c.GeneratePopulation(3,10)

I could not run the provided VBA Script.
Then I checked the registry and could find the entry InprocServer32 . After renaming it to InprocServer, following the previous issue, it worked.

• Version of Python and pywin32
  I used both Python 3.8 and 3.6, with the same result.
  3.8 is part of anaconda, and 3.6 as my local installation.
  PyWin32 Version: 227

OS is Windows 10 64 bit

[DominikRoB]

Quick Update, because I can't stop testing around:
It does not matter how I rename "InprocServer32", a new name of "asdf" or "q", did the trick as well.
I am not familar enough with the COM interface to take any meaningful conclusion out of this, but maybe it helps.

[DominikRoB]

Solved with #1704