{"id":501,"date":"2011-01-16T18:34:35","date_gmt":"2011-01-16T16:34:35","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=501"},"modified":"2015-01-25T01:59:13","modified_gmt":"2015-01-24T23:59:13","slug":"vba-l%e2%80%99outil-de-developpement-de-la-suite-msoffice-excelwordaccess%e2%80%a6","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=501","title":{"rendered":"VBA : l\u2019outil de d\u00e9veloppement de la suite MS\/Office (EXCEL\/WORD\/ACCESS\u2026)"},"content":{"rendered":"<p style=\"text-align: justify;\">VBA (pour Visual Basic for Application) est un langage de programmation puissant qui permet d\u2019automatiser des traitements avec les logiciels de la suite Office de Microsoft (EXCEL, ACCESS, WORD\u2026), d\u2019ajouter de nouvelles fonctions \u00e0 Excel et m\u00eame de transf\u00e9rer des donn\u00e9es d\u2019une application \u00e0 l\u2019autre (publipostage Word \u00e0 partir de donn\u00e9es Excel ou ACCESS\u2026). Les possibilit\u00e9s offertes par les d\u00e9veloppements VBA sont sans limite et offrent de nouvelles perspectives \u00e0 l\u2019auditeur dans tous ses travaux (notamment l\u2019audit de donn\u00e9es).<\/p>\n<p style=\"text-align: justify;\">Afin de prendre en main le module Visual Basic, il est n\u00e9cessaire\u00a0:<\/p>\n<ul>\n<li style=\"text-align: justify;\">De d\u00e9couvrir l\u2019environnement de d\u00e9veloppement VBA\u00a0: ce module, semblable sur l\u2019ensemble des applications de la suite Office, assure l\u2019\u00e9dition des programmes VBA,<\/li>\n<li style=\"text-align: justify;\">De ma\u00eetriser les mots-clefs et la syntaxe du langage,<\/li>\n<li style=\"text-align: justify;\">De comprendre la logique de programmation.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Les deux premiers items sont d\u00e9taill\u00e9s dans une litt\u00e9rature sp\u00e9cialis\u00e9e tr\u00e8s abondante, le dernier s\u2019acquiert pour beaucoup par l\u2019exp\u00e9rience.<\/p>\n<p style=\"text-align: justify;\">Afin de gagner du temps, j\u2019ai pr\u00e9f\u00e9r\u00e9 suivre une formation d\u2019initiation au VBA[1] afin d\u2019appr\u00e9hender le fonctionnement de l\u2019\u00e9diteur VBA. Cette formation, alli\u00e9e \u00e0 mon exp\u00e9rience pr\u00e9c\u00e9dente en programmation (sous Delphi notamment), m\u2019ont permis de rapidement d\u00e9velopper mes premiers codes.<\/p>\n<p style=\"text-align: justify;\">Utilit\u00e9 du VBA pour le commissaire aux comptes\u00a0:<\/p>\n<ul>\n<li style=\"text-align: justify;\">Cr\u00e9er de nouvelles fonctions\u00a0: le mot-clef \u00ab\u00a0Function\u00a0\u00bb permet d\u2019ajouter de nouvelles fonctionnalit\u00e9s \u00e0 Excel utilisables directement dans les formules de calcul.<\/li>\n<li style=\"text-align: justify;\">Cr\u00e9er des programmes de traitement ou d\u2019analyse de donn\u00e9es\u00a0(analyse de stock, de donn\u00e9es comptables\u2026).<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Le VBA est un formidable outil de d\u00e9veloppement dont l\u2019auditeur peut assur\u00e9ment tirer parti dans le cadre de ses missions d\u2019audit.<\/p>\n<p style=\"text-align: justify;\">\u00a0___________________<\/p>\n<p style=\"text-align: justify;\"><em>[1] La formation que j\u2019ai suivie \u00e9tait anim\u00e9e par Michel PIRON, expert-comptable, sp\u00e9cialis\u00e9\u00a0en informatique\u00a0: <\/em><a href=\"http:\/\/www.michelpironformation.com\/index.php\"><em>http:\/\/www.michelpironformation.com\/index.php<\/em><\/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=\"VBA%20%3A%20l%E2%80%99outil%20de%20d%C3%A9veloppement%20de%20la%20suite%20MS%2FOffice%20%28EXCEL%2FWORD%2FACCESS%E2%80%A6%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>VBA (pour Visual Basic for Application) est un langage de programmation puissant qui permet d\u2019automatiser des traitements avec les logiciels de la suite Office de Microsoft (EXCEL, ACCESS, WORD\u2026), d\u2019ajouter de nouvelles fonctions \u00e0 Excel et m\u00eame de transf\u00e9rer des donn\u00e9es d\u2019une application \u00e0 l\u2019autre (publipostage Word \u00e0 partir de donn\u00e9es Excel ou ACCESS\u2026). Les &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=501\" class=\"more-link\">Continue reading &lsquo;VBA : l\u2019outil de d\u00e9veloppement de la suite MS\/Office (EXCEL\/WORD\/ACCESS\u2026)&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=\"VBA%20%3A%20l%E2%80%99outil%20de%20d%C3%A9veloppement%20de%20la%20suite%20MS%2FOffice%20%28EXCEL%2FWORD%2FACCESS%E2%80%A6%29\";<\/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":[50,7,48,641,215],"tags":[166,1642,1633,642,221,219,217,220,1641,216],"class_list":["post-501","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-breves","category-excel","category-formation-professionnelle","category-vba","tag-analyse-de-donnees","tag-delphi","tag-excel","tag-formation","tag-function","tag-langage-de-programmation","tag-macro-commande","tag-michel-piron","tag-vba","tag-visual-basic"],"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\/501","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=501"}],"version-history":[{"count":1,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/501\/revisions"}],"predecessor-version":[{"id":5799,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/501\/revisions\/5799"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}