Unanswered: Passing a variable from excel vba to access.
I have been struggling with this for about a week now and need some help.
I have an Access Database with a macro that runs a simple (3 variable query). For simplicity and easy of use, I would like to define the 3 variable in excel and run a macro that will open access and feed it the variables.
So far, I am able to open the access database and start the macro, however I am not able to send the 3 variables from excel to access.
Here is the code in excel that opens the database: