[python-win32] running an Access VBA procedure fails

2006-10-23 Thread mchl gdbt
Hello, Just quick note to say that I solved my problem. The code I wrote in my first email, that is, import win32com.client AccessAppDB = win32com.client.GetObject("C:\db1.mdb") AccessAppDB.Run("test","Argument") works when I makepy on the access library. I guess the dynamic bind isn't able

[python-win32] running an Access VBA procedure fails

2006-10-21 Thread mchl gdbt
Hi, I have a VBA sub routine in an access file that I need to run from python. let's say Public Sub test(arg1 As String) MsgBox ("test succeeded" + arg1) End Sub ok from excel I do this Sub MyTest() strDbName = "C:\db1.mdb" Dim ObjAccess As Object Set ObjAccess = GetObject(strD