How to link data formated by a module to Excel 1

[gustavvs]

I have a piece of code in a module that coverts the date to month and year. When I go to link the database to an Excel Pivot Table I receive an "Undefined function 'MonthEnding' in this Expression'. It works fine in the query.

Any suggestions on how to fix it?

 

[vbajock]

You have to copy the same function to a VBA module in Excel - the two apps won't share the function.