import pythoncom classPythonUtilities: _public_methods_ = [ 'add_watermark' ] _reg_progid_ = "PythonDemo.Utilities" # NEVER copy the following ID # Use "print pythoncom.CreateGuid()" to make a new one. _reg_clsid_ = "{B7E3EE50-5E2A-4044-8241-4F76B1DAB885}"
if __name__=='__main__': print( "Registering COM server...") import win32com.server.register win32com.server.register.UseCommandLine(PythonUtilities)
在python种使用win32com.client.Dipatch可以调用该COM, 但是在VBA种却报错:specific module coundn't be found:
1 2 3 4 5
Sub Test() ' Create the Python COM objects. Set stringmod = CreateObject("PythonDemo.Utilities") ' Call string.split EndSub