Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
running Access procedure from Excel
Hello,
I'm trying to run a procedure in access using excel VBA. I set the access object library reference and ran this code but it hangs on the appAcc.run command; Run-time error '440': Method 'Run' of object '_Application' failed. Sub GetKenyaAPRdata() Dim appAcc As Access.Application Set appAcc = New Access.Application appAcc.Visible = False appAcc.OpenCurrentDatabase ("C:\PMS\PEPFARresults.mdb") appAcc.Run "getdata_Kenya" appAcc.Quit Set appAcc = Nothing End Sub Thanks in advance! Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Ontime's procedure while another function is running? | Excel Programming | |||
Opening an Access Database and running procedure Via Excel VBA | Excel Programming | |||
Run a MS Access Procedure from Excel | Excel Programming | |||
Getting Access Error Messages when running Access through Excel | Excel Programming | |||
Running Event Procedure When Cell Updated on Excel Worksheet | Excel Programming |