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 no...
George HepworthI have checked and compiled but there is no error and no missing references is there.
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.
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.
- It is storee in the stand alone module, not in the form module. Even then it is not executing and showing error.
- 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.
The actual macro is
I am using this function for fetching the data but not getting the required output