{"id":4015,"date":"2013-11-03T01:33:00","date_gmt":"2013-11-02T23:33:00","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=4015"},"modified":"2013-11-03T01:33:00","modified_gmt":"2013-11-02T23:33:00","slug":"excel-creez-votre-premier-programme-vba-a-laide-de-lenregistreur-de-macros-2eme-partie-enregistrer-une-macro","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=4015","title":{"rendered":"EXCEL : Cr\u00e9ez votre premier programme VBA \u00e0 l&#8217;aide de l&#8217;enregistreur de macros, 2\u00e8me partie : enregistrer une macro"},"content":{"rendered":"<p style=\"text-align: justify;\">La prochaine \u00e9tape consiste \u00e0 mettre en oeuvre l&#8217;enregistreur de macros.<\/p>\n<p style=\"text-align: justify;\">A la mani\u00e8re d&#8217;un <em>keylogger<\/em> qui enregistre tout ce que vous tapez sur votre clavier, l&#8217;enregistreur de macros m\u00e9morise toutes vos actions dans votre session Excel (saisie de formules de calcul, mise en place de filtres ou de tableaux crois\u00e9s dynamiques, changement de police ou de couleurs&#8230;) et transforme tous ces actions \u00e9l\u00e9mentaires en langage VBA.<\/p>\n<p style=\"text-align: justify;\">Pour d\u00e9marrer l&#8217;enregistrement d&#8217;une nouvelle macro, cliquer sur l&#8217;ic\u00f4ne &#8220;nouvelle macro&#8221; :<\/p>\n<div id=\"attachment_3999\" style=\"width: 458px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3999\" class=\"size-full wp-image-3999\" alt=\"Le bouton dans la zone orang\u00e9e (en bas \u00e0 gauche de la fen\u00eatre Excel) permet de d\u00e9marrer l'enregistrement d'une nouvelle macro\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-1.jpg\" width=\"448\" height=\"64\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-1.jpg 448w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-1-300x42.jpg 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/a><p id=\"caption-attachment-3999\" class=\"wp-caption-text\">Le bouton dans la zone orang\u00e9e (en bas \u00e0 gauche de la fen\u00eatre Excel) permet de d\u00e9marrer l&#8217;enregistrement d&#8217;une nouvelle macro<\/p><\/div>\n<p style=\"text-align: justify;\">Une fen\u00eatre appara\u00eet proposant de donner un nom \u00e0 votre future macro :<\/p>\n<div id=\"attachment_3997\" style=\"width: 368px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-2.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3997\" class=\"size-full wp-image-3997\" alt=\"Fen\u00eatre de l'enregistreur de macro\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-2.jpg\" width=\"358\" height=\"294\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-2.jpg 358w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-2-300x246.jpg 300w\" sizes=\"auto, (max-width: 358px) 100vw, 358px\" \/><\/a><p id=\"caption-attachment-3997\" class=\"wp-caption-text\">Fen\u00eatre de l&#8217;enregistreur de macro<\/p><\/div>\n<p style=\"text-align: justify;\">Cliquer sur le bouton Ok.<\/p>\n<p style=\"text-align: justify;\">Pour illustrer mon propos, nous allons utiliser l&#8217;exemple du sondage de comptes d&#8217;une balance comptable. Voici le tableau \u00e0 r\u00e9aliser :<\/p>\n<div id=\"attachment_4000\" style=\"width: 458px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4000\" class=\"size-full wp-image-4000\" alt=\"Tableau Excel \u00e0 r\u00e9aliser manuellement pendant le processus d'enregistrement de macro\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-3.png\" width=\"448\" height=\"298\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-3.png 448w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-3-300x199.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/a><p id=\"caption-attachment-4000\" class=\"wp-caption-text\">Tableau Excel \u00e0 r\u00e9aliser manuellement pendant le processus d&#8217;enregistrement de macro<\/p><\/div>\n<p style=\"text-align: justify;\">Il ne pr\u00e9sente aucune complication. Il ne comprend que :<\/p>\n<ul>\n<li>des encadrements de cellules,<\/li>\n<li>du texte,<\/li>\n<li>et deux formules de calcul :\n<ul>\n<li>en E11 : =SOMME(E6:E10)<\/li>\n<li>en E15 : =E11\/E13<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">R\u00e9alisez ce tableau comme vous en avez l&#8217;habitude.<\/p>\n<p style=\"text-align: justify;\">Une fois le tableau termin\u00e9, on arr\u00eate l&#8217;enregistrement de la macro :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4001 aligncenter\" alt=\"Une fois le tableau termin\u00e9, on arr\u00eate le processus d'enregistrement de macro...\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-4.jpg\" width=\"448\" height=\"73\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-4.jpg 448w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-4-300x48.jpg 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Nous allons maintenant saisir quelques informations pour mieux comprendre le fonctionnement de ce tableau :<\/p>\n<div id=\"attachment_4012\" style=\"width: 339px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-9.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4012\" class=\"size-full wp-image-4012\" alt=\"Tableau Excel apr\u00e8s saisie des informations...\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-9.png\" width=\"329\" height=\"242\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-9.png 329w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-9-300x220.png 300w\" sizes=\"auto, (max-width: 329px) 100vw, 329px\" \/><\/a><p id=\"caption-attachment-4012\" class=\"wp-caption-text\">Tableau Excel apr\u00e8s saisie des informations&#8230;<\/p><\/div>\n<p style=\"text-align: justify;\">Ce tableau permet de constater que le sondage de deux comptes clients repr\u00e9sente pr\u00e8s de 63 % de l&#8217;encours clients de la balance clients.<\/p>\n<p style=\"text-align: justify;\">Avant d&#8217;aller plus loin, nous allons enregistrer notre classeur. Notre classeur comprend une macro, nous ne pouvons plus le sauvegarder au format habituel (*.XLSX sous EXCEL 2007\/2010) mais au format *.XLSM (M pour Macro, bien entendu).<\/p>\n<div id=\"attachment_4007\" style=\"width: 445px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4007\" class=\"size-full wp-image-4007\" alt=\"Enregistrement du classeur au format XLSM (classeur Excel prenant en charge les macros)\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-5.png\" width=\"435\" height=\"426\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-5.png 435w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-5-300x293.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/a><p id=\"caption-attachment-4007\" class=\"wp-caption-text\">Enregistrement du classeur au format XLSM (classeur Excel prenant en charge les macros)<\/p><\/div>\n<p style=\"text-align: justify;\">A noter, Word est dot\u00e9 du m\u00eame enregistreur de macro que celui d&#8217;EXCEL.<\/p>\n<p style=\"text-align: justify;\">A suivre&#8230;<\/p>\n<p style=\"text-align: justify;\">Pour retrouver tous les articles de la s\u00e9rie : <a title=\"L'enregistreur de macros d'EXCEL\" href=\"http:\/\/www.auditsi.eu\/?cat=1206\">l&#8217;enregistreur de macros d&#8217;Excel<\/a>.<\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%20%3A%20Cr%C3%A9ez%20votre%20premier%20programme%20VBA%20%C3%A0%20l%27aide%20de%20l%27enregistreur%20de%20macros%2C%202%C3%A8me%20partie%20%3A%20enregistrer%20une%20macro\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>La prochaine \u00e9tape consiste \u00e0 mettre en oeuvre l&#8217;enregistreur de macros. A la mani\u00e8re d&#8217;un keylogger qui enregistre tout ce que vous tapez sur votre clavier, l&#8217;enregistreur de macros m\u00e9morise toutes vos actions dans votre session Excel (saisie de formules de calcul, mise en place de filtres ou de tableaux crois\u00e9s dynamiques, changement de police &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=4015\" class=\"more-link\">Continue reading &lsquo;EXCEL : Cr\u00e9ez votre premier programme VBA \u00e0 l&#8217;aide de l&#8217;enregistreur de macros, 2\u00e8me partie : enregistrer une macro&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%20%3A%20Cr%C3%A9ez%20votre%20premier%20programme%20VBA%20%C3%A0%20l%27aide%20de%20l%27enregistreur%20de%20macros%2C%202%C3%A8me%20partie%20%3A%20enregistrer%20une%20macro\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[39,1206,48,471,215],"tags":[227,1633,217,1641],"class_list":["post-4015","post","type-post","status-publish","format-standard","hentry","category-cas-pratiques","category-enregistreur-de-macros-dexcel","category-excel","category-langages","category-vba","tag-xlsm","tag-excel","tag-macro-commande","tag-vba"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/4015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4015"}],"version-history":[{"count":6,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/4015\/revisions"}],"predecessor-version":[{"id":4050,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/4015\/revisions\/4050"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}