Having upgraded to Office 2007 we now get Run-time error "1004":
atpvbaen.xla cound not be found errors when running macros.

We know changing the code to atpvbaen.xlam will resolve the issue for Office
2007, but we need the macros to work on both Office 2003 and Office 2007.

Any ideas or solutions?