Open an Access database and run one of its Macros from Excel
Posted
by sqlnoob
on Stack Overflow
See other posts from Stack Overflow
or by sqlnoob
Published on 2010-05-25T13:27:29Z
Indexed on
2010/05/25
13:31 UTC
Read the original article
Hit count: 290
From Excel, I need to open an Access database and run one of the database's macros.
I'm using Excel and Access 2007. Here is my code in Excel:
Sub accessMacro()
Dim appAccess As New Access.Application
Set appAccess = Access.Application
appAccess.OpenCurrentDatabase "C:\blah.mdb"
appAccess.Visible = True
appAccess.DoCmd.RunMacro "RunQueries.RunQueries"
appAccess.CloseCurrentDatabase
End Sub
In the Access Database, there is a procedure named RunQueries in a module named RunQueries. Each time I run this, I get the following error:
Runtime error '2485':
Microsoft Access Office can't find the object 'RunQueries.'
I have also tried:
appAccess.DoCmd.RunMacro "RunQueries"
and I get the same errors message. Any idea how to do this? By the way, I could go into a long explanation about why I need to do this, but let me just say that I've already argued against it, and I have to do it this way (meaning, I have to use Excel as a frontend to open several Access dbs and run their macros).
© Stack Overflow or respective owner