{"id":303,"date":"2023-11-05T12:20:57","date_gmt":"2023-11-05T12:20:57","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/"},"modified":"2023-12-06T11:35:43","modified_gmt":"2023-12-06T11:35:43","slug":"conte-as-folhas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/","title":{"rendered":"Como contar planilhas usando vba?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-889086132\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-642182323\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>No Excel, se voc\u00ea tiver muitas planilhas, poder\u00e1 usar o c\u00f3digo VBA para cont\u00e1-las rapidamente, em vez de contar manualmente ou usar qualquer f\u00f3rmula. Portanto, no artigo veremos diferentes maneiras de contar as planilhas de uma pasta de trabalho.<\/p><h2 class=\"wp-block-heading\"> Contar planilhas na pasta de trabalho ativa<\/h2><p> Aqui est\u00e1 o c\u00f3digo que voc\u00ea precisa usar para contar a planilha da pasta de trabalho ativa. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52417\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\" sizes=\"auto, \" srcset=\"\" alt=\"folhas-de-contagem-formam-o-fich\u00e1rio-ativo\" width=\"675\" height=\"344\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ThisWorkbook.Sheets.Count<\/code><\/pre><p> Neste c\u00f3digo, primeiro voc\u00ea se referiu \u00e0 pasta de trabalho ativa usando &#8220;ThisWorkbook&#8221; e se referiu a todas as planilhas, no final use o m\u00e9todo count para contar todas as planilhas. E se voc\u00ea quiser contar planilhas em vez de planilhas, use o c\u00f3digo a seguir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ThisWorkbook.Worksheets.Count<\/code><\/pre><p class=\"content-box-grey\"> <em>Links \u00fateis: <a href=\"https:\/\/exceladvisor.org\/pt\/executar-uma-macro-2\/\">Executar uma macro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/pt\/gravar-uma-macro\/\">Gravador de macro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/pt\/editor-visual-basico\/\">Editor Visual Basic<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/pt\/caderno-macro-pessoal\/\">Manual pessoal de macros<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> Contar planilhas de outra pasta de trabalho<\/h2><p> Voc\u00ea pode usar o nome da pasta de trabalho para consult\u00e1-la e depois contar as planilhas nela contidas. Suponha que voc\u00ea queira contar as planilhas da pasta de trabalho \u201cLivro1\u201d.<\/p><p> Aqui est\u00e1 o c\u00f3digo.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"sample-file.xlsx\").Sheets.Count<\/code><\/pre><p> Este c\u00f3digo fornece o n\u00famero de planilhas que voc\u00ea tem na pasta de trabalho \u201csample-file.xlsx\u201d. H\u00e1 uma coisa que voc\u00ea precisa levar: este fich\u00e1rio precisa estar aberto.<\/p><h2 class=\"wp-block-heading\"> Conte as folhas de todos os fich\u00e1rios abertos<\/h2><p> Voc\u00ea pode ter v\u00e1rias pastas de trabalho abertas ao mesmo tempo e contar todas as planilhas em todas essas pastas de trabalho.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_loop_all_sheets() Dim wb As Workbook Dim i As Long For Each wb In Application.Workbooks If wb.Name &lt;&gt; \"PERSONAL.XLSB\" Then i = i + wb.Sheets.Count End If Next wb MsgBox \"Total sheets in all the open workbooks: \" &amp; i End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Contando as folhas de um fich\u00e1rio fechado<\/h2><p> Agora temos algum c\u00f3digo aqui que se refere \u00e0 pasta de trabalho salva na \u00e1rea de trabalho do meu sistema. Quando executo esse c\u00f3digo, ele abre esta pasta de trabalho no final e conta as planilhas nela contidas e, em seguida, adiciona essa contagem \u00e0 c\u00e9lula A1.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_count_sheets() Dim wb As Workbook Application.DisplayAlerts = False Set wb = Workbooks.Open(\"C:UsersDellDesktopsample-file.xlsx\") ThisWorkbook.Sheets(1).Range(\"A1\").Value _ = wb.Sheets.Count wb.Close SaveChanges:=True Application.DisplayAlerts = True End Sub<\/code><\/pre><p> Desativamos a exibi\u00e7\u00e3o de alertas para abrir e fechar o arquivo no back-end.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/vba\/\">O que \u00e9 VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/limpar-folha\/\">LIMPAR uma planilha inteira usando VBA no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/folha-de-copia\/\">Copie e mova uma planilha no Excel usando VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/excluir-uma-planilha-1\/\">EXCLUIR uma FOLHA usando VBA no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/ocultar-planilha\/\">Ocultar e mostrar uma planilha usando VBA no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/proteja-a-folha\/\">PROTEGER e DESPROTEGER uma planilha usando VBA no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/renomear-planilha\/\">RENOMEAR uma planilha usando VBA no Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-303","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como contar planilhas usando VBA no Excel?<\/title>\n<meta name=\"description\" content=\"Neste tutorial, voc\u00ea encontrar\u00e1 diferentes maneiras de contar planilhas no Excel usando VBA.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como contar planilhas usando VBA no Excel?\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, voc\u00ea encontrar\u00e1 diferentes maneiras de contar planilhas no Excel usando VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:35:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/\",\"name\":\"Como contar planilhas usando VBA no Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\",\"datePublished\":\"2023-11-05T12:20:57+00:00\",\"dateModified\":\"2023-12-06T11:35:43+00:00\",\"description\":\"Neste tutorial, voc\u00ea encontrar\u00e1 diferentes maneiras de contar planilhas no Excel usando VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como contar planilhas usando vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como contar planilhas usando VBA no Excel?","description":"Neste tutorial, voc\u00ea encontrar\u00e1 diferentes maneiras de contar planilhas no Excel usando VBA.","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:\/\/exceladvisor.org\/pt\/conte-as-folhas\/","og_locale":"pt_PT","og_type":"article","og_title":"Como contar planilhas usando VBA no Excel?","og_description":"Neste tutorial, voc\u00ea encontrar\u00e1 diferentes maneiras de contar planilhas no Excel usando VBA.","og_url":"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:35:43+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/","url":"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/","name":"Como contar planilhas usando VBA no Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png","datePublished":"2023-11-05T12:20:57+00:00","dateModified":"2023-12-06T11:35:43+00:00","description":"Neste tutorial, voc\u00ea encontrar\u00e1 diferentes maneiras de contar planilhas no Excel usando VBA.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/conte-as-folhas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como contar planilhas usando vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=303"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/303\/revisions"}],"predecessor-version":[{"id":931,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/303\/revisions\/931"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}