How to remove AutoOpen macro

[Aline]

Hi!
Using VBA I try to develop a procedure that will loop a
folder and will remove the AutoOpen macro from every file.
Due to an error in a template every file built from that
template contains the macro.

Thank for any help!
Aline

 

[Jonathan West]

Hi!
Using VBA I try to develop a procedure that will loop a
folder and will remove the AutoOpen macro from every file.
Due to an error in a template every file built from that
template contains the macro.

Are you sure that each document contains the macro? If the template is
available, then whenever a document based on the template is opened, the
AutoOpen mano in the template will run.

Try just deleting the AutoOpen macro in the template, and see if that cures
the problem.