{"id":3995,"date":"2013-11-02T15:37:52","date_gmt":"2013-11-02T13:37:52","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=3995"},"modified":"2015-02-15T11:54:02","modified_gmt":"2015-02-15T10:54:02","slug":"excel-creez-votre-premier-programme-vba-a-laide-de-lenregistreur-de-macros","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=3995","title":{"rendered":"EXCEL : Cr\u00e9ez votre premier programme VBA \u00e0 l&#8217;aide de l&#8217;enregistreur de macros"},"content":{"rendered":"<p style=\"text-align: justify;\">Le langage VBA d&#8217;EXCEL est un outil puissant et utile dans notre quotidien professionnel. Le VBA automatise la r\u00e9alisation de traitements r\u00e9currents (calculs, tris, rapprochements, mises en forme&#8230;). L&#8217;apprentissage d&#8217;un nouveau langage n&#8217;\u00e9tant pas une t\u00e2che ais\u00e9e, EXCEL est dot\u00e9 d&#8217;un enregistreur de macros fort pratique facilitant l&#8217;exp\u00e9rimentation.<\/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\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-2.jpg\" alt=\"Fen\u00eatre de l'enregistreur de macro\" 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;\">L&#8217;objet du pr\u00e9sent article est de pr\u00e9senter le fonctionnement de l&#8217;enregistreur de macros et de r\u00e9aliser des macros simples et efficaces. Cet article sera d\u00e9coup\u00e9 en plusieurs parties, chaque partie \u00e9tant l&#8217;occasion de d\u00e9couvrir de nouvelles fonctionnalit\u00e9s d&#8217;EXCEL. A l&#8217;issue de cette s\u00e9ries d&#8217;articles, le lecteur assidu saura automatiser certaines t\u00e2ches, c&#8217;est s\u00fbr et garanti !<\/p>\n<p style=\"text-align: justify;\">L&#8217;enregistreur de macros offre deux int\u00e9r\u00eats ind\u00e9niables :<\/p>\n<ul>\n<li>Les macros enregistr\u00e9es peuvent \u00eatre r\u00e9ex\u00e9cut\u00e9es \u00e0 loisir permettant ult\u00e9rieurement de reproduire automatiquement les actions ex\u00e9cut\u00e9es ant\u00e9rieurement manuellement.<\/li>\n<li>L&#8217;enregistreur de macros permet de cr\u00e9er des macro-commandes VBA sans connaissance pr\u00e9alable du langage VBA offrant \u00e0 l&#8217;utilisateur l&#8217;opportunit\u00e9 d&#8217;un apprentissage en douceur de ce langage ; en effet, comme nous le verrons un peu plus tard, l&#8217;enregistreur de macros produit de v\u00e9ritables programmes r\u00e9dig\u00e9s en langage VBA que l&#8217;utilisateur peut d\u00e9cortiquer \u00e0 temps perdu.<\/li>\n<\/ul>\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<p style=\"text-align: justify;\"><span style=\"font-size: small;\"><em>Je propose au lecteur impatient la lecture de quelques articles sur le VBA et sur le langage Basic (dont le VBA d\u00e9rive) : <a title=\"S'initier au langage VBA d'EXCEL\" href=\"http:\/\/www.auditsi.eu\/?p=1659\">S&#8217;initier au langage VBA d&#8217;EXCEL<\/a>.<\/em><\/span><\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a title=\"Programmer en VBA\" href=\"http:\/\/www.auditsi.eu\/?cat=1569\">Programmer en VBA<\/a> \/ <a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"http:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d&#8217;articles Ma\u00eetriser 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\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Le langage VBA d&#8217;EXCEL est un outil puissant et utile dans notre quotidien professionnel. Le VBA automatise la r\u00e9alisation de traitements r\u00e9currents (calculs, tris, rapprochements, mises en forme&#8230;). L&#8217;apprentissage d&#8217;un nouveau langage n&#8217;\u00e9tant pas une t\u00e2che ais\u00e9e, EXCEL est dot\u00e9 d&#8217;un enregistreur de macros fort pratique facilitant l&#8217;exp\u00e9rimentation. L&#8217;objet du pr\u00e9sent article est de pr\u00e9senter &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=3995\" class=\"more-link\">Continue reading &lsquo;EXCEL : Cr\u00e9ez votre premier programme VBA \u00e0 l&#8217;aide de l&#8217;enregistreur de macros&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\";<\/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":[1205,39,1206,471,1326,1569,215],"tags":[1204,815,1647,1633,217,1641,224],"class_list":["post-3995","post","type-post","status-publish","format-standard","hentry","category-articles-a-suites","category-cas-pratiques","category-enregistreur-de-macros-dexcel","category-langages","category-maitriser-excel","category-programmer-en-vba","category-vba","tag-autoformation","tag-automatisation","tag-basic","tag-excel","tag-macro-commande","tag-vba","tag-word"],"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\/3995","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=3995"}],"version-history":[{"count":18,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/3995\/revisions"}],"predecessor-version":[{"id":5896,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/3995\/revisions\/5896"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}