Prev: Parsing html with Beautifulsoup
Next: DCT transform (API)? (scipy or otherwise)
From: diego on 10 Dec 2009 04:50
I ran this script:
---------------------------
class Example(object):
_public_methods_ = ['Add','Mul']
_reg_progid_ = 'MyPython.Example'
_reg_clsid_ = '{E39ECD8C-7FAF-48B0-B914-1202319499D4}'

def Add(self,a,b): return a+b

def Mul(self,a,b): return a*b

if __name__ == '__main__':
import win32com.server.register
win32com.server.register.UseCommandLine(Example)
---------------------------------
connecting to this COM server works with following VBS-script:
---------------------------------
Set ex = CreateObject("MyPython.Example")
msgbox ex.Add(1, 2)
---------------------------------

when i run following VBA script in excel
---------------------------------
Sub Testit()
Set ex = CreateObject("MyPython.Example")
MsgBox ex.Add(1, 2)
End Sub
---------------------------------

i get the error:
Run-time error '-2137024770 (8007007e)':
Automation error
The specified module could not be found



Any ideas what the problem could be?
Already searched a long time for solutions but did not find any....

thanks,
diego
From: Michel Claveau - MVP on 10 Dec 2009 05:52
Hi !

Warning with lower/uppercases!
Try to make two versions of your methods (ex.: "add" & "ADD"), for study.

@+
--
MCI

From: diego on 10 Dec 2009 07:26
On 10 Dez., 11:52, "Michel Claveau -
MVP"<enleverLesX_XX...(a)XmclavXeauX.com.invalid> wrote:
> Hi !
>
> Warning with lower/uppercases!
> Try to make two versions of your methods (ex.: "add" & "ADD"), for study.
>
> @+
> --
> MCI


The error comes already at the first line of Excel/VBA code:
Set ex = CreateObject("MyPython.Example")


rgds,e
From: diego on 10 Dec 2009 07:27
On 10 Dez., 11:52, "Michel Claveau -
MVP"<enleverLesX_XX...(a)XmclavXeauX.com.invalid> wrote:
> Hi !
>
> Warning with lower/uppercases!
> Try to make two versions of your methods (ex.: "add" & "ADD"), for study.
>
> @+
> --
> MCI


The error comes already at the first line of Excel/VBA code:
Set ex = CreateObject("MyPython.Example")


rgds,e
From: diego on 10 Dec 2009 10:55
the problem was that i had never installed python on my workstation.
just had a Python25 folder with a batch-file that was adjustin the
PATH and executing %PYTHONHOME%python.exe
installed Python properly and now everything works fine....
 | 
Pages: 1
Prev: Parsing html with Beautifulsoup
Next: DCT transform (API)? (scipy or otherwise)