Running an Access VBA Module from an Excel VBA Macro 2

[padinka]

I need to get an Excel VBA macro to run a VBA module in an access database. Can someone give me some code???

 

[Amiel]

Sure,

Private Sub RunAccessStruff()
Dim objAccess as object
Set objAccess = CreateObject("Access.Application.8&quot

objAccess.OpenCurrentDatabase("C:\data\myAccess.mdb&quot
objAccess.Application.Run "Procedure1", Arg1, Arg2, Arg3

Set objAccess= Nothing

This will create an instance of an Access Application and call a function named 'Procedure1', then shut down the Application. There is actually a more efficient way to execute 'Function1' however using the Scripting component.

Enough? Let me know.






End Sub

 

[padinka]

THANK YOU, THANK YOU, THANK YOU. It works beautifully. I had given up on anyone answering my question. I really appreciate the help.

 

[padinka]

THANK YOU, THANK YOU, THANK YOU. It works beautifully. I had given up on anyone answering my question. I really appreciate the help.

 

[Amiel]

It's been a while since I've gotten so much thanks ...
glad it helped, come back soon !