Running Excel Macro

J

Jim Jackson

In my Access database I have a routine which opens and Excel Workbook and
calls a macro within the workbook. It usually runs smoothly but at times
fails to find the macro. The last time this happened, I renamed the macro
and changed the related line in the routine and it worked smoothly again.

Is there some way to protect against this happening?

Thanks for suggestions.
 
Top