{"id":17002,"date":"2021-02-12T09:15:00","date_gmt":"2021-02-12T14:15:00","guid":{"rendered":"https:\/\/ccdmd.qc.ca\/resources\/automatiser-avec-vba-en-bureautique\/"},"modified":"2024-05-29T14:36:04","modified_gmt":"2024-05-29T18:36:04","slug":"automatiser-avec-vba-en-bureautique","status":"publish","type":"product","link":"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/","title":{"rendered":"Automatiser avec VBA en bureautique"},"content":{"rendered":"<p>Ce manuel pr\u00e9sente d\u2019abord un survol de l\u2019enregistreur de macros simples, puis les rudiments du langage Visual Basic pour Applications n\u00e9cessaires \u00e0 la cr\u00e9ation de macros complexes. Tout au long des chapitres, plusieurs exemples et mises en situation sont pr\u00e9sent\u00e9s. Des projets int\u00e9grateurs sont propos\u00e9s en exercice.<\/p>\n<p>Les connaissances acquises permettront de gagner du temps dans l\u2019ex\u00e9cution des t\u00e2ches r\u00e9p\u00e9titives et fastidieuses avec les logiciels de la suite Microsoft Office sous l\u2019environnement Windows.<\/p>\n<p>Aucune connaissance pr\u00e9alable en programmation n\u2019est n\u00e9cessaire.<\/p>\n<h3 id=\"sommaire\">Sommaire<\/h3>\n<p>Introduction aux macros \u2013 Initiation aux macros complexes \u2013 Principaux concepts du langage VBA \u2013 Gestion des macros complexes \u2013 Int\u00e9gration de diff\u00e9rents logiciels \u2013 Analyse des besoins \u2013 Planification du travail \u2013 D\u00e9veloppement et v\u00e9rification des r\u00e9sultats \u2013 Production du guide d\u2019utilisation \u2013 Projets int\u00e9grateurs<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ce manuel pr\u00e9sente d\u2019abord un survol de l\u2019enregistreur de macros simples, puis les rudiments du langage Visual Basic pour Applications n\u00e9cessaires \u00e0 la cr\u00e9ation de macros complexes. Tout au long des chapitres, plusieurs exemples et mises en situation sont pr\u00e9sent\u00e9s. Des projets int\u00e9grateurs sont propos\u00e9s en exercice. Les connaissances acquises [&hellip;]<\/p>\n","protected":false},"featured_media":26441,"template":"","meta":{"_acf_changed":false,"inline_featured_image":false},"product_brand":[],"product_cat":[2307,2364],"product_tag":[2930,2931,2932,2933,2934,2935,2936,2937,2938,2939,2940,2941,2942,2943],"class_list":["post-17002","product","type-product","status-publish","has-post-thumbnail","product_cat-digital-textbook","product_cat-textbook","product_tag-analyse-de-besoins-en","product_tag-automatisation-en","product_tag-bureautique-en","product_tag-guide-dutilisation-en","product_tag-macros-en","product_tag-methode-de-travail-en","product_tag-office-en","product_tag-planification-du-travail-en","product_tag-procedure-en","product_tag-programmation-en","product_tag-taches-repetitives-en","product_tag-vba-en","product_tag-visual-basic-for-applications-en","product_tag-windows-en","discipline-412-office-system-technology","programme-office-system-technology-412-a0","collections-featured","first","instock","purchasable","product-type-variable"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Automatiser avec VBA en bureautique | Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automatiser avec VBA en bureautique | Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique\" \/>\n<meta property=\"og:description\" content=\"Ce manuel pr\u00e9sente d\u2019abord un survol de l\u2019enregistreur de macros simples, puis les rudiments du langage Visual Basic pour Applications n\u00e9cessaires \u00e0 la cr\u00e9ation de macros complexes. Tout au long des chapitres, plusieurs exemples et mises en situation sont pr\u00e9sent\u00e9s. Des projets int\u00e9grateurs sont propos\u00e9s en exercice. Les connaissances acquises [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/\" \/>\n<meta property=\"og:site_name\" content=\"Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/CCDMD.fr\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-29T18:36:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ccdmd.qc.ca\/wp-content\/uploads\/2021\/02\/automatiser_vba@2x-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"850\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/resources\\\/automatiser-avec-vba-en-bureautique\\\/\",\"url\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/resources\\\/automatiser-avec-vba-en-bureautique\\\/\",\"name\":\"Automatiser avec VBA en bureautique | Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/resources\\\/automatiser-avec-vba-en-bureautique\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/resources\\\/automatiser-avec-vba-en-bureautique\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ccdmd.qc.ca\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/automatiser_vba@2x-1.jpg\",\"datePublished\":\"2021-02-12T14:15:00+00:00\",\"dateModified\":\"2024-05-29T18:36:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/resources\\\/automatiser-avec-vba-en-bureautique\\\/#breadcrumb\"},\"inLanguage\":\"en-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/resources\\\/automatiser-avec-vba-en-bureautique\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-CA\",\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/resources\\\/automatiser-avec-vba-en-bureautique\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ccdmd.qc.ca\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/automatiser_vba@2x-1.jpg\",\"contentUrl\":\"https:\\\/\\\/ccdmd.qc.ca\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/automatiser_vba@2x-1.jpg\",\"width\":1000,\"height\":850},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/resources\\\/automatiser-avec-vba-en-bureautique\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/accueil\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resources\",\"item\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/resources\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Automatiser avec VBA en bureautique\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/\",\"name\":\"Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique\",\"description\":\"Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique\",\"publisher\":{\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/#organization\"},\"alternateName\":\"CCDMD\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-CA\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/#organization\",\"name\":\"CCDMD\",\"alternateName\":\"Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique\",\"url\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-CA\",\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ccdmd.qc.ca\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/Creer-le-savoir.png\",\"contentUrl\":\"https:\\\/\\\/ccdmd.qc.ca\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/Creer-le-savoir.png\",\"width\":696,\"height\":696,\"caption\":\"CCDMD\"},\"image\":{\"@id\":\"https:\\\/\\\/ccdmd.qc.ca\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"http:\\\/\\\/facebook.com\\\/CCDMD.fr\",\"https:\\\/\\\/ca.linkedin.com\\\/company\\\/ccdmd\",\"https:\\\/\\\/www.youtube.com\\\/@CCDMD_fr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Automatiser avec VBA en bureautique | Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/","og_locale":"en_US","og_type":"article","og_title":"Automatiser avec VBA en bureautique | Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique","og_description":"Ce manuel pr\u00e9sente d\u2019abord un survol de l\u2019enregistreur de macros simples, puis les rudiments du langage Visual Basic pour Applications n\u00e9cessaires \u00e0 la cr\u00e9ation de macros complexes. Tout au long des chapitres, plusieurs exemples et mises en situation sont pr\u00e9sent\u00e9s. Des projets int\u00e9grateurs sont propos\u00e9s en exercice. Les connaissances acquises [&hellip;]","og_url":"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/","og_site_name":"Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique","article_publisher":"http:\/\/facebook.com\/CCDMD.fr","article_modified_time":"2024-05-29T18:36:04+00:00","og_image":[{"width":1000,"height":850,"url":"https:\/\/ccdmd.qc.ca\/wp-content\/uploads\/2021\/02\/automatiser_vba@2x-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/","url":"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/","name":"Automatiser avec VBA en bureautique | Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique","isPartOf":{"@id":"https:\/\/ccdmd.qc.ca\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/#primaryimage"},"image":{"@id":"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/#primaryimage"},"thumbnailUrl":"https:\/\/ccdmd.qc.ca\/wp-content\/uploads\/2021\/02\/automatiser_vba@2x-1.jpg","datePublished":"2021-02-12T14:15:00+00:00","dateModified":"2024-05-29T18:36:04+00:00","breadcrumb":{"@id":"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/#breadcrumb"},"inLanguage":"en-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/"]}]},{"@type":"ImageObject","inLanguage":"en-CA","@id":"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/#primaryimage","url":"https:\/\/ccdmd.qc.ca\/wp-content\/uploads\/2021\/02\/automatiser_vba@2x-1.jpg","contentUrl":"https:\/\/ccdmd.qc.ca\/wp-content\/uploads\/2021\/02\/automatiser_vba@2x-1.jpg","width":1000,"height":850},{"@type":"BreadcrumbList","@id":"https:\/\/ccdmd.qc.ca\/en\/resources\/automatiser-avec-vba-en-bureautique\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/ccdmd.qc.ca\/en\/accueil\/"},{"@type":"ListItem","position":2,"name":"Resources","item":"https:\/\/ccdmd.qc.ca\/en\/resources\/"},{"@type":"ListItem","position":3,"name":"Automatiser avec VBA en bureautique"}]},{"@type":"WebSite","@id":"https:\/\/ccdmd.qc.ca\/en\/#website","url":"https:\/\/ccdmd.qc.ca\/en\/","name":"Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique","description":"Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique","publisher":{"@id":"https:\/\/ccdmd.qc.ca\/en\/#organization"},"alternateName":"CCDMD","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ccdmd.qc.ca\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-CA"},{"@type":"Organization","@id":"https:\/\/ccdmd.qc.ca\/en\/#organization","name":"CCDMD","alternateName":"Centre coll\u00e9gial de d\u00e9veloppement de mat\u00e9riel didactique","url":"https:\/\/ccdmd.qc.ca\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-CA","@id":"https:\/\/ccdmd.qc.ca\/en\/#\/schema\/logo\/image\/","url":"https:\/\/ccdmd.qc.ca\/wp-content\/uploads\/2025\/08\/Creer-le-savoir.png","contentUrl":"https:\/\/ccdmd.qc.ca\/wp-content\/uploads\/2025\/08\/Creer-le-savoir.png","width":696,"height":696,"caption":"CCDMD"},"image":{"@id":"https:\/\/ccdmd.qc.ca\/en\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/CCDMD.fr","https:\/\/ca.linkedin.com\/company\/ccdmd","https:\/\/www.youtube.com\/@CCDMD_fr"]}]}},"_links":{"self":[{"href":"https:\/\/ccdmd.qc.ca\/en\/wp-json\/wp\/v2\/product\/17002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ccdmd.qc.ca\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/ccdmd.qc.ca\/en\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ccdmd.qc.ca\/en\/wp-json\/wp\/v2\/media\/26441"}],"wp:attachment":[{"href":"https:\/\/ccdmd.qc.ca\/en\/wp-json\/wp\/v2\/media?parent=17002"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/ccdmd.qc.ca\/en\/wp-json\/wp\/v2\/product_brand?post=17002"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/ccdmd.qc.ca\/en\/wp-json\/wp\/v2\/product_cat?post=17002"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/ccdmd.qc.ca\/en\/wp-json\/wp\/v2\/product_tag?post=17002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}