{"id":536,"date":"2011-02-22T01:13:19","date_gmt":"2011-02-22T00:13:19","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=536"},"modified":"2014-02-16T14:08:51","modified_gmt":"2014-02-16T12:08:51","slug":"vba-outil-dechange-de-donnees-entre-les-applications-msoffice","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=536","title":{"rendered":"VBA : Outil d&#8217;\u00e9change de donn\u00e9es entre les applications MS\/OFFICE"},"content":{"rendered":"<p style=\"text-align: justify;\">Le VBA permet d\u2019automatiser les \u00e9changes de donn\u00e9es entre applications de la suite Office. Il est ainsi possible de lire des donn\u00e9es dans une table Access, d\u2019effectuer les calculs dans Excel, de pr\u00e9senter les donn\u00e9es calcul\u00e9es dans un rapport sous Word et d\u2019envoyer le document g\u00e9n\u00e9r\u00e9 par m\u00e9l \u00e0 l\u2019aide d\u2019Outlook, tout \u00e7a automatiquement en VBA.<\/p>\n<p style=\"text-align: justify;\">C\u2019est dans cette optique que j\u2019ai r\u00e9alis\u00e9 une application qui r\u00e9alise les synth\u00e8ses de cycle d\u2019audit automatiquement \u00e0 partir, entre autres, de la balance g\u00e9n\u00e9rale annot\u00e9e (cf. <a title=\"MoCoAUDITSOFT - Pr\u00e9sentation pour SCRIBD v\u00b02 (bas\u00e9e sur v\u00b0 4 du manuel) \" href=\"http:\/\/www.auditsi.eu\/?wpfb_dl=197\">http:\/\/www.auditsi.eu\/?wpfb_dl=197<\/a>).<\/p>\n<p style=\"text-align: justify;\">Pour lire l&#8217;article en version int\u00e9grale : cf en bas de page.<\/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%20Outil%20d%27%C3%A9change%20de%20donn%C3%A9es%20entre%20les%20applications%20MS%2FOFFICE\";<\/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 VBA permet d\u2019automatiser les \u00e9changes de donn\u00e9es entre applications de la suite Office. Il est ainsi possible de lire des donn\u00e9es dans une table Access, d\u2019effectuer les calculs dans Excel, de pr\u00e9senter les donn\u00e9es calcul\u00e9es dans un rapport sous Word et d\u2019envoyer le document g\u00e9n\u00e9r\u00e9 par m\u00e9l \u00e0 l\u2019aide d\u2019Outlook, tout \u00e7a automatiquement en &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=536\" class=\"more-link\">Continue reading &lsquo;VBA : Outil d&#8217;\u00e9change de donn\u00e9es entre les applications MS\/OFFICE&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%20Outil%20d%27%C3%A9change%20de%20donn%C3%A9es%20entre%20les%20applications%20MS%2FOFFICE\";<\/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":[7,6,470],"tags":[1634,250,248,249,242,184,1633,428,252,251,241,243,240,1641,224],"class_list":["post-536","post","type-post","status-publish","format-standard","hentry","category-breves","category-mission-du-commissaire-aux-comptes","category-techniques-daudit","tag-audit-de-donnees","tag-cdec","tag-cell","tag-cells","tag-cycle-daudit","tag-documentation-des-travaux","tag-excel","tag-formalisation","tag-format","tag-left","tag-microsoft","tag-sheetsnomfeuille","tag-suite-office","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\/536","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=536"}],"version-history":[{"count":3,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/536\/revisions"}],"predecessor-version":[{"id":4571,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/536\/revisions\/4571"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}