Thanks for the message,
It works from Excel side, but Access macro does not recongnize the parameter
from Excel.

The Access Macro execute the same parameter no matter what Excel sends to.

any ideas?

Thanks millions,

"XP" wrote:

The following works for me (change parameters and include full path to your db:

Dim oAccess As Object, oDB As Object
Set oAccess = CreateObject("Access.Application")
oAccess.Visible = True
oAccess.OpenCurrentDatabase "MyFullDBPathName.mdb"
oAccess.Run "MyTestMacro", "MyParameter"

HTH

"Souris" wrote:

I need run an Access macro from Excel spreadsheet and pass a paramter from a
cell of the spreadsheet.

Is it possible to have a macro to accept paramter in Access?
If yes, can I pass parameter from excel to access macro?
If yes, any example to do so?

Your information is great appreciated,