VBA

Category: Livres,Informatique et Internet,Programmation et langages

VBA Details

Visual Basic pour Applications (VBA) est un langage de programmation complet incorporé dans chacune applications Office(r) : Word(r), Excel(r), Access(r), PowerPoint(r) look(r). Il permet de créer des macros, des mini-applications " intelligentes " ou encore de piloter les autres applications Office. Destiné aussi bien aux débutants qu'aux utilisateurs initiés, cet ouvrage passe en revue l'ensemble du langage. Vous apprendrez, grâce à des exemples pratiques immédiatement utilisables, à créer et à gérer vos propres macros à partir d'Excel afin d'automatiser vos tâches les plus répétitives... Un gain de temps et d'efficacité en perspective En lire plus En lire moins P.when('DynamicIframe').execute(function(DynamicIframe){ var BookDescriptionIframe = null, bookDescEncodedData = "Visual%20Basic%20pour%20Applications%20%28VBA%29%20est%20un%20langage%20de%20programmation%20complet%20incorpor%C3%A9%20dans%20chacune%20applications%20Office%28r%29%20%3A%20Word%28r%29%2C%20Excel%28r%29%2C%20Access%28r%29%2C%20PowerPoint%28r%29%20look%28r%29.%20Il%20permet%20de%20cr%C3%A9er%20des%20macros%2C%20des%20mini-applications%20%22%20intelligentes%20%22%20ou%20encore%20de%20piloter%20les%20autres%20applications%20Office.%20Destin%C3%A9%20aussi%20bien%20aux%20d%C3%A9butants%20qu%27aux%20utilisateurs%20initi%C3%A9s%2C%20cet%20ouvrage%20passe%20en%20revue%20l%27ensemble%20du%20langage.%20Vous%20apprendrez%2C%20gr%C3%A2ce%20%C3%A0%20des%20exemples%20pratiques%20imm%C3%A9diatement%20utilisables%2C%20%C3%A0%20cr%C3%A9er%20et%20%C3%A0%20g%C3%A9rer%20vos%20propres%20macros%20%C3%A0%20partir%20d%27Excel%20afin%20d%27automatiser%20vos%20t%C3%A2ches%20les%20plus%20r%C3%A9p%C3%A9titives...%20Un%20gain%20de%20temps%20et%20d%27efficacit%C3%A9%20en%20perspective%20%3Cbr", bookDescriptionAvailableHeight, minBookDescriptionInitialHeight = 112, options = {}, iframeId = "bookDesc_iframe"; function resizeCallback() { P.guardFatal("bookDescription", function() { // Get the line-height of the iframe var iframe = document.getElementById(iframeId); var iframeDocument = iframe.contentDocument; if (false && iframeDocument && iframeDocument.defaultView) { // Set the height to the number of lines specified var numLines = parseInt(0, 10); // Get the line-height of the iframe var iframeContent = iframeDocument.getElementById("iframeContent"); // Compute the line height var lineHeight = iframeDocument.defaultView.getComputedStyle(iframeContent, null).getPropertyValue("line-height"); // Parse the line height lineHeight = parseFloat(lineHeight); bookDescriptionAvailableHeight = Math.round(lineHeight * numLines); } else { var bdOffsetTop = document.getElementById("bookDescription_feature_div").offsetTop; var imageBlockOffsetTop = document.getElementById("booksImageBlock_feature_div").offsetTop; var imageBlockHeight = document.getElementById("booksImageBlock_feature_div").offsetHeight; bookDescriptionAvailableHeight = imageBlockOffsetTop imageBlockHeight -bdOffsetTop - 30; if(bookDescriptionAvailableHeight < minBookDescriptionInitialHeight) { bookDescriptionAvailableHeight = minBookDescriptionInitialHeight; } } var psTotalHeight = document.getElementById("postBodyPS").offsetHeight; if(psTotalHeight > bookDescriptionAvailableHeight 30){ if(document.getElementById("bdSeeLessPrompt").style.display == "none"){ document.getElementById("outer_postBodyPS").style.height = bookDescriptionAvailableHeight 'px'; document.getElementById("psPlaceHolder").style.display ="block"; document.getElementById("bdSeeAllPrompt").style.display ="block"; } else{ document.getElementById("outer_postBodyPS").style.height = psTotalHeight 'px'; } } else{ document.getElementById("outer_postBodyPS").style.height = psTotalHeight 'px'; document.getElementById("psPlaceHolder").style.display ="none"; document.getElementById("bdSeeAllPrompt").style.display ="block"; document.getElementById("bdSeeLessPrompt").style.display ="none"; document.getElementById("bdExpanderIcon").className = document.getElementById("bdExpanderIcon").className.replace("rotate",""); } })(); } options.iframeId = iframeId; options.iframeWrapperId = "bookDesc_iframe_wrapper"; options.overriddenCSSId = "bookDesc_override_CSS"; options.encodedIframeContent = bookDescEncodedData; options.initialResizeCallback = resizeCallback;BookDescriptionIframe = new DynamicIframe(options); P.guardFatal("bookDescription", function() { BookDescriptionIframe.createIframe(); }) ();if ((typeof BookDescriptionIframe != 'undefined') && (BookDescriptionIframe instanceof DynamicIframe)) { P.when('jQuery').execute(function($) { $(window).resize(function() { P.guardFatal("bookDescription", function() { BookDescriptionIframe.resizeIframe(resizeCallback); }) (); }); $(window).bind('imageResize', function() { P.guardFatal("bookDescription", function() { BookDescriptionIframe.resizeIframe(resizeCallback); }) (); }); }); }});

Reviews