mettre à jour macro excel / update macro in EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-1944445%22%20slang%3D%22fr-FR%22%3Eupdate%20macro%20excel%20%2F%20update%20macro%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1944445%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%20I%20have%20several%20thousand%20EXCEL%20files%20with%20the%20same%20macro.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20update%20some%20information%20in%20this%20macro%20(to%20do%20for%20all%20EXCEL%20files)%2C%20is%20there%20a%20way%20to%20do%20a%20batch%20processing%20to%20avoid%20opening%20these%20thousands%20of%20files%20one%20by%20one%20and%20change%20the%20code%3FMy%20macro%20is%20locked%20by%20a%20password%20(which%20I%20know).%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello!%20I%20have%20several%20thousand%20of%20EXCEL%20file%20with%20macro.%3C%2FP%3E%3CP%3EI%20want%20to%20do%20some%20changes%20in%20the%20code%20of%20macro%20(same%20modification%20for%20all%20files)%2C%20is%20there%20a%20solution%20to%20do%20the%20change%20without%20open%20each%20file%3F%20my%20macro%20is%20protected%20by%20a%20password%20(I%20know%20the%20password).%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1944445%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Bonjour, j'ai plusieurs milliers de fichiers EXCEL avec le même macro.

J'aimerais mettre à jours certaines informations dans ce macro (à faire pour tous les fichiers EXCEL), y a-t-il un moyen de faire un traitement par lot pour éviter d'ouvrir ces milliers de fichiers un par un et modifier le code ? Mon macro est verrouillé par un mot de passe (que je connais).

Merci d'avance.

 

 

Hello ! I have several thousand of EXCEL file with macro.

I want to do some modifications in the code of macro (same modification for all files), is there a solution to do the change without open each file ? my macro is protected by a password (I know the password).

Thanks in advance.

0 Replies