Unanswered: Calling Access VBA functions from Excel
Rightio I have a macro in Excel that creates a bunch of datatables depended on a year you enter, when this is called I want to call a macro in Access that checks whether the query of that specific year exists and if not create it.
Now I can't do this with a Macro so I've used a VBA macro
Klasgeld_Query(syear As String)
BUT now here my question, I know Access Macros can be called with doCmd.RunMacro but this doesn't work with a vba macro.
So is there any way to call a VBA macro from Excel?
(I have thought about calling the function with a Access Macro and then calling the macro with Excel, but I don't know how to work the parameter into that?)
Dim appAccess As New Access.Application
Const conPath As String = "C:\event\EVENT REPORT97.MDB"
Application.ScreenUpdating = False
Application.DisplayAlerts = False
.DoCmd.RunMacro "Update Data"
Set appAccess = Nothing
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.