Automate Excel from Access

Hi,

I have an excel workbook that has a public function called MonthlyUpdate in a module called modReporting. I am trying to automate this process from Access, but I don't know how to call MonthlyUpdate from the VBA code in my Access Project. What would you all recommend?

Thanks,
Ranthalion

See the Excel tutorial link in my signature (even tho it is for VB6, it applies to to Access VBA too), one of the "FAQ" bits at the end explains how to call the code.

Thanks for the info and great job on the tutorials!