I have a access database with a Sub, that i would like to execute from Excel.
I have found this code, that works:
Dim A As Object
Set A = CreateObject("Access.Application")
A.Visible = True
A.OpenCurrentDatabase ("C:\Documents and Settings\rcrill\My
A.Run "ImportExcel"<---------------------This Fails
But i my case the database is already open, so is it possible to just tell the already open database to just run the Sub without opening the same database again?