pythoncom.CLSCTX_LOCAL_SERVER means this COM object will be hosted by
python.exe - so COM/office is going to look up the registry to get a
command-line to execute. As written, that will just re-register the COM
server - so yes, you do want that `localserver.serve()`. The default of
CLSCTX_INPROC_SERVER generally doesn't need an explicit serve() as
python.exe isn't used - the DLLs are loaded directly into office - but
that probably isn't going to help in a concrete way (ie, the underlying
problem would probably exist in both cases)
Assuming it still fails with that: it might be that this command is
failing for reasons - eg, if you installed pywin32 via pip and didn't
run the pywin32_postinstall script I can imagine things going wrong. The
.exe installer runs that for you though.
You mention you found the entry in the registry - does executing that
command in a "clean" environment (ie, without any special environment
variables etc, from a directory unrelated to python - ie, trying to
emulate the same environment office itself runs in) work OK? If it fails
importing modules etc, that's probably the same failure when COM tries
to start it.
You mention "running code as Administrator" - is Office and this
registration code running as the exact same user?
I've currently no environments with Office available, so can't really
test at the moment.
HTH,
Mark
On 9/11/2022 2:53 am, Brian Johnson wrote:
Hi python-win32 community.
I am trying to get this toy COM server (code is below) to work. It is
the sample code from /"Python Programming for Win32"/ and adapted for
python 3.10. When I test it using VBA in Word, I get this error:
Run-time error '429':
ActiveX component can't create object
* I don't know if I am missing one a required _reg_param_ that is
needed for Win10.
* Is there is an extra step I need to take to register/run the COM server?
* I don't know if win32com.server.localserver.serve [] is necessary.
* Does the class need an __init__ method to do something?
I appreciate any help or insight into getting this to work. Thank you!
Sincerely, Brian
*Context*:
* Windows 10, python 3.10, Office 365, running python code as
Administrator
* I have verified the python class works in python only.
* I tried registering/unregistering using both options shown below.
Both appear to work - no error messages. I can find info about the
COM Server using Regedit.
* I tried the --debug flag, but it didn't provide any verbosity.
* I'm learning COM, but the info about it is sparse and generally very
abstract.
*Python script, SimpleCOMServer.py:*
"""A sample COM server - almost as small as they come."""
# import sys
importpythoncom
importwin32com.server.register
classPythonUtilities:
"""We expose a simple method in a Python COM object."""
_reg_clsctx_= pythoncom.CLSCTX_LOCAL_SERVER
_public_methods_= ["SplitString"]
_reg_progid_= "PythonDemos.Utilities"
_reg_desc_= "PythonDemos Test COM Server"
# NEVER copy the following ID
# Use "print(pythoncom.CreateGUID())" to made a new on.
_reg_clsid_= "{819E8336-00B5-4025-979A-46EE1EF411B7}"
# for Python 3.7+
#
https://stackoverflow.com/questions/1054849/consuming-python-com-server-from-net <https://stackoverflow.com/questions/1054849/consuming-python-com-server-from-net>
_reg_verprogid_= "PythonDemos.Utilities.1"
# <filename>.<classname>
_reg_class_spec_= "SimpleCOMServer.PythonUtilities"
defSplitString(self, val, separator=None):
"""Split a string by a separator."""
# if separator is not None:
# return val.split(separator)
# else:
# return val.split()
ifseparatorisnotNone:
returnstr(val).split(str(separator))
else:
returnstr(val).split()
# Add code so that when this script is run by python e.e, it self-registers.
if__name__== "__main__":
print("Registering COM server...")
win32com.server.register.UseCommandLine(PythonUtilities)
# if "--register" in sys.argv[1:] or "--unregister" in sys.argv[1:]:
# win32com.server.register.UseCommandLine(PythonUtilities)
# else:
# # start the server.
# from win32com.server.localserver import serve
# serve(["{819E8336-00B5-4025-979A-46EE1EF411B7}"])
*Word VBA macro:*
Sub TestPython()
Dim PythonUtils As Object
Set PythonUtils = CreateObject("PythonDemos.Utilities")
response = PythonUtils.SplitString("Hello from VB")
For Each Item In response
MsgBox Item
Next
End Sub
_______________________________________________
python-win32 mailing list
python-win32@python.org
https://mail.python.org/mailman/listinfo/python-win32
_______________________________________________
python-win32 mailing list
python-win32@python.org
https://mail.python.org/mailman/listinfo/python-win32
