{"id":14976,"date":"2018-09-09T20:50:49","date_gmt":"2018-09-09T20:50:49","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=14976"},"modified":"2022-08-17T19:15:13","modified_gmt":"2022-08-17T19:15:13","slug":"vba-referencing-and-early-binding-vs-late-binding","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/","title":{"rendered":"Early Binding v\/s Late Binding in Excel VBA Programming"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.17.6″ custom_padding=”0px|0px|0px|0px|true|true” da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row admin_label=”row” _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0px|0px|0px|0px|true|true” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” custom_padding=”0px|0px|0px|0px|true|true” global_colors_info=”{}”]Early and Late Binding is a common phenomenon across computer programming languages. In simple terms, Binding means – how and when methods or properties of an Object are compiled and checked. <\/span><\/p>\n

In the case of Excel VBA [COM – Component Object Model] – this occurs when you are trying to automate something which is not part of default object library of Excel<\/strong> (in this case). <\/p>\n

For example: <\/span><\/h3>\n

If you are trying to access Outlook, Word, Internet Explorer, RegEx <\/a>etc. using Excel VBA – you need to link those Object Libraries in your Excel to be able to use all the functions, methods, properties, etc. from that Object Library. It is similar to Import statement in Java<\/em> or #Include in C <\/em>.<\/span> If you do not know about these languages, you don’t need to worry about it. I am going to explain this concept in “Excel Only Context”<\/em> and no other programming language.<\/p>\n

Before you could access those Objects in your Excel VBA programming, you need to add those references in your Excel Workbook. This process of Referencing non-default object libraries is also called Binding<\/em>. <\/p>\n

This Binding can be done in two ways in Excel VBA:-<\/span>
\n1.<\/span>Early Binding or Static Binding
\n2.<\/span>Late Binding Or Dynamic Binding<\/p>\n

What is an early binding in Excel VBA <\/h1>\n

As the name suggests, in early binding you add relevant reference before your program compiles. Early binding is done by adding the reference in Excel VBE screen itself. By doing this, all the methods, functions etc. are loaded.<\/p>\n

Steps to add Reference in Excel VBA Screen<\/h2>\n

Step 1.<\/span> Go to VB Editor Screen (Alt+F11)
\nStep 2.<\/span> Tools \u2013> References\u2026
\n

\"Add-Reference-Step-1\"<\/a>

Add-Reference-Step-1<\/p><\/div>
\nStep 3.<\/span> You can see list of so many references – These are are libraries
\nStep 4.<\/span> Select all your libraries which you want to use it in your program – For Example – PowerPoint<\/p>\n

Step 5.<\/span> Click OK<\/p>\n

After clicking OK<\/strong> this object library is added in your VBE Project.
\nTo check that, press F2<\/span> and on the Object Library Window of Excel VBA, you can see that PowerPoint Object Library is added there as shown in below picture.<\/p>\n

\"Object<\/a>

Object Libraries in Excel VBA<\/p><\/div>\n

This is where you can see all the classes, methods, properties etc. related to the Reference you added in Excel VBA.<\/p>\n

That’s all. Now you can declare variables of all the types defined in that Object Library, use their corresponding methods, properties etc. You can see in the below image.
\n

\"EarlyBinding-Intellisense\"<\/a>

EarlyBinding-Intellisense<\/p><\/div><\/p>\n

This is why it is called early binding. Object, methods, properties etc. are checked during compilation and not at run time.<\/p>\n

Early binding is defined something like following:<\/p>\n

\n\nDim newPowerPoint As PowerPoint.Application\nSet newPowerPoint = New PowerPoint.Application\n<\/code>\n<\/pre>\n
OR<\/h2>\n
\nDim newPowerPoint As New PowerPoint.Application<\/code><\/pre>\n
Advantages of Early Binding<\/h2>\n
Following are the main advantage about Early binding:
\nBetter Performance: <\/strong> Early binding is considerably faster than late binding. Reason for better performance is that program is already compiled before running it.
\nVBE Intellisense:<\/span> One of the major advantage of Early Binding<\/strong> is that VBE intellisense start displaying all the object, methods, properties etc. after pressing dot (.) like any default Object. Refer below image
\n
\"EarlyBinding-Intellisense\"<\/a>
EarlyBinding-Intellisense<\/p><\/div>
\nAccess to Object Model in Object Browser: <\/span> You have full access to the Object Model referenced in VBE like shown in the above pictures.<\/p>\n
Disadvantages of Early Binding <\/h2>\n
Compatibility Error: <\/span>This is version compatibility prone method of binding. If the version of the application is different in the computer where you are running the VBA application, then you will get a compilation error. <\/p>\n
For example: <\/span><\/h2>\n
if the Object Library which you have referenced in your Excel File is XYZ-V-1.0 and shared it with your colleague who has next version of this object library V-2.0. In this case, program will not even compile because if you have reference V-1.0 which this file is missing in his\/her computer.<\/p>\n
More Object References – Bigger file size<\/span> The more number of reference you add in your Excel VBA application, bigger the file size becomes and it takes longer time to compile.<\/p>\n
This was all about Early binding. <\/p>\n
What is Late binding in Excel VBA <\/h1>\n
Opposite to the early binding, in late binding, Objects are checked and compiled at run time. You do not have to reference the Object Library before you run the program. In late binding Objects are created run time and then method or property related statements are compiled and then executed.
\nIf your typed method or property does not exist, then you would not get any error until you run the program unlike early binding.<\/p>\n
This is how late binding created in VBA. First you need to define a variable of Object type and then using CreateObject(“Object Library Name”)<\/span> method of VBA, you can create and instance of that Object.<\/p>\n
Since Object Libraries are not referenced before, you can not use New<\/strong> keyword to instantiate the Object.<\/p>\n
\n\nSub Create_PowerPoint_Object\n'Define one variable of Object Type to hold the Application Object\nDim objNewPowerPoint as Object\n'Create an Object for PowerPoint Application\nSet objNewPowerPoint = CreateObject(\"PowerPoint.Application\")\nEnd Sub\n<\/code>\n<\/pre>\n
Advantages of Late Binding<\/h2>\n
Version Independent: <\/strong> Since you are not referencing a version specific Object Library and referring instance of that Object in your program, it will not through any error if shared to another computer with a different version.<\/p>\n
Note:<\/strong> If the Method, properties or objects are changed in different version then it may fail even by using this late binding.<\/p>\n
Faster compilation<\/strong> Since there is no Object Library files attached with the VBA project, file size remains as is and compilation becomes faster.<\/p>\n
Faster compilation<\/strong> <\/p>\n
Disadvantages of Late Binding <\/h2>\n
No Intellisense<\/strong> In this method you do not see intellisense any more. To use any of the method, property etc, you need to know the exact name of it otherwise you will see error at run time.
\nCompilation Error at run time<\/strong> All compilation error occurs at run time. You can not uncover such issue during compilation.
\nNo Access to Object Model in Object Library<\/span> In VBA project, you do not see Object Model in Object Library in excel VBA like Early Binding.[\/et_pb_text][et_pb_blurb title=”You may also like these articles” use_icon=”on” font_icon=”||fa||900″ _builder_version=”4.17.6″ _module_preset=”0249c68e-4de8-4f44-84ff-a9b1850785b6″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]LIBRARY NOT REGISTERED \u2013 AUTOMATION ERROR<\/a>
\nHOW TO INTERACT WITH HTML PAGES FROM EXCEL<\/a>
\nEXCEL MACRO TUTORIAL : VBA CONTROL PROPERTY<\/a>
\nREFERENCES IN EXCEL FORMULAS \u2013 ABSOLUTE AND RELATIVE<\/a>
\nEXCEL VBA BASICS : ALL ABOUT DEBUGGING EXCEL VBA CODE<\/a>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"
Early and Late Binding is a common phenomenon across computer programming languages. In simple terms, Binding means – how and when methods or properties of an Object are compiled and checked. In the case of Excel VBA [COM – Component Object Model] – this occurs when you are trying to automate something which is not […]<\/p>\n","protected":false},"author":45,"featured_media":242628,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[5204],"tags":[],"class_list":["post-14976","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vba-programming"],"yoast_head":"\nEarly Binding v\/s Late Binding in Excel VBA Programming<\/title>\n<meta name=\"description\" content=\"Early or late binding in Excel VBA? Advantages and disadvantages of early and late binding in Excel VBA. Difference between early and late binding?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Early Binding v\/s Late Binding in Excel VBA Programming\" \/>\n<meta property=\"og:description\" content=\"Early or late binding in Excel VBA? Advantages and disadvantages of early and late binding in Excel VBA. Difference between early and late binding?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-09T20:50:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-17T19:15:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/09\/binding.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"562\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Early Binding v\/s Late Binding in Excel VBA Programming\",\"datePublished\":\"2018-09-09T20:50:49+00:00\",\"dateModified\":\"2022-08-17T19:15:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/\"},\"wordCount\":797,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/09\/binding.jpeg\",\"articleSection\":[\"VBA Programming\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/\",\"name\":\"Early Binding v\/s Late Binding in Excel VBA Programming\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/09\/binding.jpeg\",\"datePublished\":\"2018-09-09T20:50:49+00:00\",\"dateModified\":\"2022-08-17T19:15:13+00:00\",\"description\":\"Early or late binding in Excel VBA? Advantages and disadvantages of early and late binding in Excel VBA. Difference between early and late binding?\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/09\/binding.jpeg\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/09\/binding.jpeg\",\"width\":960,\"height\":562,\"caption\":\"Early and Late Binding in VBA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VBA Programming\",\"item\":\"https:\/\/vmlogger.com\/excel\/vba-programming\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Early Binding v\/s Late Binding in Excel VBA Programming\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Early Binding v\/s Late Binding in Excel VBA Programming","description":"Early or late binding in Excel VBA? Advantages and disadvantages of early and late binding in Excel VBA. Difference between early and late binding?","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:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/","og_locale":"en_US","og_type":"article","og_title":"Early Binding v\/s Late Binding in Excel VBA Programming","og_description":"Early or late binding in Excel VBA? Advantages and disadvantages of early and late binding in Excel VBA. Difference between early and late binding?","og_url":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2018-09-09T20:50:49+00:00","article_modified_time":"2022-08-17T19:15:13+00:00","og_image":[{"width":960,"height":562,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/09\/binding.jpeg","type":"image\/jpeg"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Early Binding v\/s Late Binding in Excel VBA Programming","datePublished":"2018-09-09T20:50:49+00:00","dateModified":"2022-08-17T19:15:13+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/"},"wordCount":797,"commentCount":2,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/09\/binding.jpeg","articleSection":["VBA Programming"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/","url":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/","name":"Early Binding v\/s Late Binding in Excel VBA Programming","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/09\/binding.jpeg","datePublished":"2018-09-09T20:50:49+00:00","dateModified":"2022-08-17T19:15:13+00:00","description":"Early or late binding in Excel VBA? Advantages and disadvantages of early and late binding in Excel VBA. Difference between early and late binding?","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/09\/binding.jpeg","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/09\/binding.jpeg","width":960,"height":562,"caption":"Early and Late Binding in VBA"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2018\/09\/vba-referencing-and-early-binding-vs-late-binding\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"VBA Programming","item":"https:\/\/vmlogger.com\/excel\/vba-programming\/"},{"@type":"ListItem","position":3,"name":"Early Binding v\/s Late Binding in Excel VBA Programming"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/14976"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=14976"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/14976\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242628"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=14976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=14976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=14976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}