{"id":2961,"date":"2016-03-19T07:50:55","date_gmt":"2016-03-19T07:50:55","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?page_id=2961"},"modified":"2016-03-19T07:50:55","modified_gmt":"2016-03-19T07:50:55","slug":"using-open-xml-package-editor-to-create-a-ribbon-button-that-runs-a-vba-function","status":"publish","type":"page","link":"https:\/\/www.ericwhite.com\/blog\/using-open-xml-package-editor-to-create-a-ribbon-button-that-runs-a-vba-function\/","title":{"rendered":"Using Open XML Package Editor to Create a Ribbon Button that runs a VBA Function"},"content":{"rendered":"<p>Sometimes an end-to-end solution requires some level of customization in the operation of a word-processing document or a spreadsheet. &nbsp;Of course, this is where VBA can be useful. &nbsp;Sometimes the best solution requires a combination of developer techniques, including Open XML, VBA or VSTO, SharePoint, and\/or other tools. &nbsp;In this screen-cast, I walk through the simplest way to customize the ribbon (using the Open XML Package Editor PowerTool for Visual Studio 2010) and create a button on the ribbon that calls a VBA function.<\/p>\n<p>In a subsequent screen-cast, I&#8217;ll show how to create a VBA add-in using the Open XML Package Editor, and in a third screen-cast, I&#8217;ll show how you can integrate VBA code with Open XML code to create a business application that uses Excel tables to provide interesting functionality.<\/p>\n<p><iframe loading=\"lazy\" title=\"Create-Ribbon-Button-Run-VBA.wmv\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/hn3Qkp4Jw34?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes an end-to-end solution requires some level of customization in the operation of a word-processing document or a spreadsheet. &nbsp;Of course, this is where VBA can be useful. &nbsp;Sometimes the best solution requires a combination of developer techniques, including Open XML, VBA or VSTO, SharePoint, and\/or other tools. &nbsp;In this screen-cast, I walk through the [&hellip;]<\/p>\n","protected":false},"author":10567,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_s2mail":"","footnotes":""},"class_list":["post-2961","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/users\/10567"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/comments?post=2961"}],"version-history":[{"count":1,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2961\/revisions"}],"predecessor-version":[{"id":2962,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2961\/revisions\/2962"}],"wp:attachment":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/media?parent=2961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}