Executing Access Macro in Visual Basic 6.0
Posted on 2006-11-20
I have code where I dont reference access in my project itself. Can I execute a macro using the folliowing code? I dont see the DoCmd options under my properties. I would rather just use something similar to what I have and not reference access. Here is what I use now:
Set wsAccessWs = DBEngine.Workspaces(0)
Set dbAccessDb = wsAccessWs.OpenDatabase(App.Path & gsDBName, False, False)
the dbAccessDb has .execute and then a query name. But I dont see anything for executing a macro. Thanks all.