{"id":6521,"date":"2016-02-21T21:09:32","date_gmt":"2016-02-21T20:09:32","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=6521"},"modified":"2016-02-21T21:09:32","modified_gmt":"2016-02-21T20:09:32","slug":"vba-excel-activer-une-reference","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=6521","title":{"rendered":"VBA, EXCEL : activer une r\u00e9f\u00e9rence"},"content":{"rendered":"<p style=\"text-align: justify;\">Les\u00a0fonctions du langage VBA sont class\u00e9es dans diff\u00e9rentes biblioth\u00e8ques (ou r\u00e9f\u00e9rences). Il est n\u00e9cessaire d&#8217;activer les biblioth\u00e8ques comprenant les fonctions utilis\u00e9es dans une macro, faute de quoi la macro ne pourra s&#8217;ex\u00e9cuter et un message d&#8217;erreur s&#8217;affichera.<\/p>\n<p style=\"text-align: justify;\"><a href=\"http:\/\/www.auditsi.eu\/?attachment_id=6523\" rel=\"attachment wp-att-6523\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6523\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2016\/02\/EXCEL-EDI-VBA-R\u00e9f\u00e9rences.png\" alt=\"EXCEL - EDI VBA - R\u00e9f\u00e9rences\" width=\"449\" height=\"357\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2016\/02\/EXCEL-EDI-VBA-R\u00e9f\u00e9rences.png 449w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2016\/02\/EXCEL-EDI-VBA-R\u00e9f\u00e9rences-300x239.png 300w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Pour activer ou d\u00e9sactiver une biblioth\u00e8que, aller dans le menu Outils, R\u00e9f\u00e9rences&#8230; et cocher la ou les biblioth\u00e8ques concern\u00e9es.<\/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%2C%20EXCEL%20%3A%20activer%20une%20r%C3%A9f%C3%A9rence\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les\u00a0fonctions du langage VBA sont class\u00e9es dans diff\u00e9rentes biblioth\u00e8ques (ou r\u00e9f\u00e9rences). Il est n\u00e9cessaire d&#8217;activer les biblioth\u00e8ques comprenant les fonctions utilis\u00e9es dans une macro, faute de quoi la macro ne pourra s&#8217;ex\u00e9cuter et un message d&#8217;erreur s&#8217;affichera. Pour activer ou d\u00e9sactiver une biblioth\u00e8que, aller dans le menu Outils, R\u00e9f\u00e9rences&#8230; et cocher la ou les biblioth\u00e8ques &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=6521\" class=\"more-link\">Continue reading &lsquo;VBA, EXCEL : activer une r\u00e9f\u00e9rence&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%2C%20EXCEL%20%3A%20activer%20une%20r%C3%A9f%C3%A9rence\";<\/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":[1569,215],"tags":[827,217,1719,1641],"class_list":["post-6521","post","type-post","status-publish","format-standard","hentry","category-programmer-en-vba","category-vba","tag-bibliotheque","tag-macro-commande","tag-references","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\/6521","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=6521"}],"version-history":[{"count":3,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6521\/revisions"}],"predecessor-version":[{"id":6525,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6521\/revisions\/6525"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}