{"id":27162,"date":"2022-12-22T18:58:32","date_gmt":"2022-12-22T13:28:32","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/"},"modified":"2022-12-22T18:58:32","modified_gmt":"2022-12-22T13:28:32","slug":"solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/","title":{"rendered":"[Solved] Don&#8217;t know how program a button to open file explorer that can open any document"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-49115277\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"49115277\" data-parentid=\"49076958\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Someone else was able to answer my question on another forum. Credit goes to Trebor76 from Ozgrid for the user friendly solution. This is the solution that was given to me. This was pretty plug and play.  <\/p>\n<pre><code>Option Explicit\nSub Acessdocumentexplorer_Click()\n\n    'The following has been adapted from here:\n    'https:\/\/msdn.microsoft.com\/en-us\/vba\/excel-vba\/articles\/application-\nfiledialog-property-excel\n\n    Dim lngCount As Long\n\n    'Open the file dialog\n    With Application.FileDialog(msoFileDialogOpen)\n        .AllowMultiSelect = True\n        .Show\n        'Display paths of each file selected\n        For lngCount = 1 To .SelectedItems.Count\n            'MsgBox .SelectedItems(lngCount)\n            CreateObject(\"Shell.Application\").ShellExecute \n.SelectedItems(lngCount)\n        Next lngCount\n    End With\n\nEnd Sub\n<\/code><\/pre>\n<p>Just as I needed all this code does is Simply open the file explorer when I click on the &#8220;Access Document Explorer&#8221; button that I have on my worksheet. From there it has the capability of opening any document\/program I need opened\/run.<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.ozgrid.com\/forum\/forum\/help-forums\/excel-vba-macros\/1200343-don-t-know-how-to-program-button-to-open-file-explorer-that-can-open-any-file-type\">Ozgrid forum Link<\/a>  <\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Don&#8217;t know how program a button to open file explorer that can open any document <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Someone else was able to answer my question on another forum. Credit goes to Trebor76 from Ozgrid for the user friendly solution. This is the solution that was given to me. This was pretty plug and play. Option Explicit Sub Acessdocumentexplorer_Click() &#8216;The following has been adapted from here: &#8216;https:\/\/msdn.microsoft.com\/en-us\/vba\/excel-vba\/articles\/application- filedialog-property-excel Dim lngCount As Long &#8230; <a title=\"[Solved] Don&#8217;t know how program a button to open file explorer that can open any document\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/\" aria-label=\"More on [Solved] Don&#8217;t know how program a button to open file explorer that can open any document\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[400,401],"class_list":["post-27162","post","type-post","status-publish","format-standard","hentry","category-solved","tag-excel","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Don&#039;t know how program a button to open file explorer that can open any document - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Don&#039;t know how program a button to open file explorer that can open any document - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Someone else was able to answer my question on another forum. Credit goes to Trebor76 from Ozgrid for the user friendly solution. This is the solution that was given to me. This was pretty plug and play. Option Explicit Sub Acessdocumentexplorer_Click() &#039;The following has been adapted from here: &#039;https:\/\/msdn.microsoft.com\/en-us\/vba\/excel-vba\/articles\/application- filedialog-property-excel Dim lngCount As Long ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-22T13:28:32+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Don&#8217;t know how program a button to open file explorer that can open any document\",\"datePublished\":\"2022-12-22T13:28:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/\"},\"wordCount\":120,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"excel\",\"vba\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/\",\"name\":\"[Solved] Don't know how program a button to open file explorer that can open any document - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-12-22T13:28:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Don&#8217;t know how program a button to open file explorer that can open any document\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Don't know how program a button to open file explorer that can open any document - JassWeb","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:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Don't know how program a button to open file explorer that can open any document - JassWeb","og_description":"[ad_1] Someone else was able to answer my question on another forum. Credit goes to Trebor76 from Ozgrid for the user friendly solution. This is the solution that was given to me. This was pretty plug and play. Option Explicit Sub Acessdocumentexplorer_Click() 'The following has been adapted from here: 'https:\/\/msdn.microsoft.com\/en-us\/vba\/excel-vba\/articles\/application- filedialog-property-excel Dim lngCount As Long ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/","og_site_name":"JassWeb","article_published_time":"2022-12-22T13:28:32+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Don&#8217;t know how program a button to open file explorer that can open any document","datePublished":"2022-12-22T13:28:32+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/"},"wordCount":120,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["excel","vba"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/","url":"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/","name":"[Solved] Don't know how program a button to open file explorer that can open any document - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-22T13:28:32+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-dont-know-how-program-a-button-to-open-file-explorer-that-can-open-any-document\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Don&#8217;t know how program a button to open file explorer that can open any document"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/27162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=27162"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/27162\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=27162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=27162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=27162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}