A query can call a function, and a function can call Excel, even though we are in Access. This is Part 2, and steps you through the VBA that "wraps" Excel functionality so we can use its worksheet functions in Access.
The declaration statement defines the function name and its return data type. The values it needs to calculate are specified as parameters, or arguments.
Create an error handler that will exit without the user realizing there might have been a problem, and define a default value of zero for the function return value.
See how to open Excel and refer to it so code in Access can use it. Reuse the Excel application object to make susbsequent processing faster ... so, how do we clean that up?
Even though topics may be technical, I do my best to consider that a beginner may be watching, so extra detail is added. Hopefully not so much that more advanced users turn away ... maybe you will comment and let me know your thoughts about this? Thanks!
have an awesome day,
1. Dimension oExcel as object at top of module
2. Name of function follows the "Function" keyword