Forum Discussion
Accessing excel files using microsoft access
Hi
I am trying to automate excel file using Microsoft access. I am using macros for that, but I am not able to get the required output.
I have created one public function in microsoft access and now I am using that function as a "autoexec" macro in access db, but as i am trying to run that macro it is showing that function name not found.
Now when I am trying to use this function inside the macro, I am getting error
And i am getting the below error
So what should i do not to get rid of this error
any help would be appreciated
12 Replies
What is the name of the Module that the Function is contained within?
Make sure you do not have a Function inside a Module of the same name, it will result in Error 2425.
-Verify that the Module name and Function name are different.
One common reason for that particular error is that there is a missing reference. Does your code compile?
how to check whether my code is getting compiled or not
Open the VBE and select Debug. Then click on "Compile YourDatabaseNameAppearsHere"
If there is a problem, it'll quickly throw an error.
Also look for missing references here:
Any missing or incorrect references will be flagged as "Missing".
