{"version":"1.0","provider_name":"Let&#039;s excel in Excel","provider_url":"https:\/\/vmlogger.com\/excel","author_name":"Vishwamitra Mishra","author_url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/","title":"VBA Guide to Interact with Text Files \u2013 Part \u2013 2 of 2","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"3c0SU99ZL2\"><a href=\"https:\/\/vmlogger.com\/excel\/2017\/08\/vba-tutorial-to-read-data-from-text-files\/\">VBA Guide to Interact with Text Files \u2013 Part \u2013 2 of 2<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/vmlogger.com\/excel\/2017\/08\/vba-tutorial-to-read-data-from-text-files\/embed\/#?secret=3c0SU99ZL2\" width=\"600\" height=\"338\" title=\"&#8220;VBA Guide to Interact with Text Files \u2013 Part \u2013 2 of 2&#8221; &#8212; Let&#039;s excel in Excel\" data-secret=\"3c0SU99ZL2\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/* ]]> *\/\n<\/script>\n","description":"VBA code to read text file. Input and Line Input statements in VBA. What is EOF () function in excel VBA? VBA code to read delimited text files. Use of Split() function","thumbnail_url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2017\/08\/TextFile.jpg"}