{"id":4039,"date":"2013-11-09T22:13:40","date_gmt":"2013-11-09T20:13:40","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=4039"},"modified":"2015-02-15T12:39:12","modified_gmt":"2015-02-15T11:39:12","slug":"excel-creez-votre-premier-programme-vba-a-laide-de-lenregistreur-de-macros-3eme-partie-executer-une-macro","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=4039","title":{"rendered":"EXCEL : Cr\u00e9ez votre premier programme VBA \u00e0 l&#8217;aide de l&#8217;enregistreur de macros, 3\u00e8me partie : ex\u00e9cuter une macro"},"content":{"rendered":"<p style=\"text-align: justify;\">L&#8217;int\u00e9r\u00eat des macros est d&#8217;ex\u00e9cuter un ensemble de t\u00e2ches automatiquement. C&#8217;est ce que nous allons aborder dans cette partie.<\/p>\n<p style=\"text-align: justify;\">Avant d&#8217;aller plus loin, nous devons ajouter un nouveau menu \u00e0 EXCEL : le menu &#8220;D\u00e9veloppeur&#8221;. C&#8217;est \u00e0 partir des options offertes par ce menu que nous acc\u00e9dons \u00e0 l&#8217;environnement de d\u00e9veloppement int\u00e9gr\u00e9 (EDI) d&#8217;EXCEL.<\/p>\n<p style=\"text-align: justify;\">Pour ajouter ce menu au ruban d&#8217;EXCEL, allez dans &#8220;Fichier&#8221; puis &#8220;Options&#8221;. La fen\u00eatre des options d&#8217;Excel appara\u00eet :<\/p>\n<div id=\"attachment_4040\" style=\"width: 458px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4040\" class=\"size-full wp-image-4040\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-6.png\" alt=\"Options Excel : ajouter le menu &quot;D\u00e9veloppeur&quot;\" width=\"448\" height=\"165\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-6.png 448w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-6-300x110.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/a><p id=\"caption-attachment-4040\" class=\"wp-caption-text\">Options Excel : ajouter le menu &#8220;D\u00e9veloppeur&#8221;<\/p><\/div>\n<p style=\"text-align: justify;\">Cliquez sur &#8220;Personnaliser le ruban&#8221; puis cochez &#8220;D\u00e9veloppeur&#8221;, enfin fermez la fen\u00eatre. Le menu &#8220;D\u00e9veloppeur&#8221; appara\u00eet maintenant dans le ruban Excel :<\/p>\n<div id=\"attachment_4043\" style=\"width: 458px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-7.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4043\" class=\"size-full wp-image-4043\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-7.jpg\" alt=\"Le menu D\u00e9veloppeur\" width=\"448\" height=\"90\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-7.jpg 448w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-7-300x60.jpg 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/a><p id=\"caption-attachment-4043\" class=\"wp-caption-text\">Le menu D\u00e9veloppeur<\/p><\/div>\n<p style=\"text-align: justify;\">Ceci fait, nous allons ex\u00e9cuter la macro r\u00e9alis\u00e9e lors de la <a title=\"EXCEL : Cr\u00e9ez votre premier programme VBA \u00e0 l\u2019aide de l\u2019enregistreur de macros, 2\u00e8me partie : enregistrer une macro\" href=\"http:\/\/www.auditsi.eu\/?p=4015\">2\u00e8me partie de cet article<\/a>. Pour ce faire, ouvrez le classeur et allez sur l&#8217;onglet &#8220;Feuil2&#8221;. Normalement, cette feuille de calcul est enti\u00e8rement vierge. Cliquez sur l&#8217;ic\u00f4ne &#8220;Macros&#8221; du menu &#8220;D\u00e9veloppeur&#8221; :<\/p>\n<div id=\"attachment_4044\" style=\"width: 436px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-10.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4044\" class=\"size-full wp-image-4044\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-10.png\" alt=\"Liste des macros en m\u00e9moire\" width=\"426\" height=\"369\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-10.png 426w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-10-300x259.png 300w\" sizes=\"auto, (max-width: 426px) 100vw, 426px\" \/><\/a><p id=\"caption-attachment-4044\" class=\"wp-caption-text\">Liste des macros en m\u00e9moire<\/p><\/div>\n<p style=\"text-align: justify;\">S\u00e9lectionnez la macro &#8220;Macro1&#8221; puis cliquer sur le bouton &#8220;Ex\u00e9cuter&#8221;.<\/p>\n<p style=\"text-align: justify;\">La macro s&#8217;ex\u00e9cute&#8230; et le tableau cr\u00e9\u00e9 manuellement par vous dans l&#8217;onglet &#8220;Feuil1&#8221; r\u00e9appara\u00eet automatiquement !<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4000 aligncenter\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/11\/Macro-3.png\" alt=\"Tableau Excel \u00e0 r\u00e9aliser manuellement pendant le processus d'enregistrement de macro\" 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>N&#8217;est-ce pas magique ?<\/p>\n<p style=\"text-align: justify;\">A partir de ce moment, le monde de l&#8217;automatisation des t\u00e2ches s&#8217;ouvre \u00e0 vous ! R\u00e9fl\u00e9chissez aux t\u00e2ches de votre quotidien que vous pourriez faire r\u00e9aliser par votre ordinateur et essayez de les reproduire \u00e0 l&#8217;aide de l&#8217;enregistreur de macros.<\/p>\n<p style=\"text-align: justify;\">A suivre\u2026<\/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\u2019enregistreur de macros d\u2019Excel<\/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%203%C3%A8me%20partie%20%3A%20ex%C3%A9cuter%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>L&#8217;int\u00e9r\u00eat des macros est d&#8217;ex\u00e9cuter un ensemble de t\u00e2ches automatiquement. C&#8217;est ce que nous allons aborder dans cette partie. Avant d&#8217;aller plus loin, nous devons ajouter un nouveau menu \u00e0 EXCEL : le menu &#8220;D\u00e9veloppeur&#8221;. C&#8217;est \u00e0 partir des options offertes par ce menu que nous acc\u00e9dons \u00e0 l&#8217;environnement de d\u00e9veloppement int\u00e9gr\u00e9 (EDI) d&#8217;EXCEL. Pour &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=4039\" class=\"more-link\">Continue reading &lsquo;EXCEL : Cr\u00e9ez votre premier programme VBA \u00e0 l&#8217;aide de l&#8217;enregistreur de macros, 3\u00e8me partie : ex\u00e9cuter 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%203%C3%A8me%20partie%20%3A%20ex%C3%A9cuter%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,215],"tags":[815,254,1633,217,1216,1641],"class_list":["post-4039","post","type-post","status-publish","format-standard","hentry","category-cas-pratiques","category-enregistreur-de-macros-dexcel","category-excel","category-vba","tag-automatisation","tag-edi","tag-excel","tag-macro-commande","tag-menu-developpeur","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\/4039","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=4039"}],"version-history":[{"count":7,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/4039\/revisions"}],"predecessor-version":[{"id":5905,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/4039\/revisions\/5905"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}