[python-win32] Is it possible for some VBA code in Excel to create a Python class and access it as a inproc COM server without write access to the registry?

Harrington, Paul Tue, 25 Aug 2009 21:44:17 -0700

My (casual) use of python within Excel has been to register COM servers in 
Python and get a handle to a local server out-of-process instance via 
CreateObject in Auto_Open. This works fine for me as I have a local admin 
account with access to HKEY_CLASSES_ROOT.


I would like Excel users to access functionality implemented in Python by 
calling functions/subs which are VBA wrappers around invocations on the COM 
server. Having pythoncom take care of the marshalling is preferable to the 
'eval' interface offered by MSScriptControl.ScriptControl. I would love some 
mechanism whereby the Excel VBA code could -- on startup -- create an inprocess 
COM server implemented in Python.

Is this possible?

pjjH

_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32

[python-win32] Is it possible for some VBA code in Excel to create a Python class and access it as a inproc COM server without write access to the registry?

Reply via email to