Accessing excel files using microsoft access

[SuperUser20]

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

[#2]

@SuperUser20 

One common reason for that particular error is that there is a missing reference. Does your code compile?

[#3]

@George_Hepworth 

how to check whether my code is getting compiled or not

[#4]

@SuperUser20 

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". 

[#5]

@George HepworthI have checked and compiled but there is no error and no missing references is there.

[#6]

Where is the function located, in a standalone module or in the class module of a form?
If the latter, you'll need to add that form reference as part of the call to the function. Better to have it in a standalone module instead.

[#7]

It is storee in the stand alone module, not in the form module. Even then it is not executing and showing error.

[#8]

The problem appears to be in the way your macro tries to call the function then. SInce we've only seen the error message, maybe you can share the actual macro as well.

[#9]

@George_Hepworth 

The actual macro is

I  am using this function for fetching the data but not getting the required output

[#10]

U@SuperUser20 

Unfortunately, it's not possible to diagnose this problem with the limitations imposed by the static posts in this discussion. Nothing appears to be out of the ordinary. The problem occurs during runtime, which we can't watch.

It might help if you can upload a sample copy of the accdb as an attachment, with just enough sample data to see how it's supposed to work.

[#11]

Also, when presenting a problem, it is almost always more helpful to describe behavior, not outcomes. "...not getting the required output" is a statement of an outcome. What we need is a description of the actual behavior. "I expected a recordset to be exported to Excel. Instead I get an error message. The error message says....."

[#12]

@SuperUser20

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.

[#13]

Cross Posted:
https://techcommunity.microsoft.com/t5/access/regarding-macros-and-function-in-microsoft-access/m-p/...