{"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 - Part - 1 of 2","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"yXd3y2iFfa\"><a href=\"https:\/\/vmlogger.com\/excel\/2017\/08\/vba-to-open-and-write-text-files\/\">VBA Guide to Interact with Text Files &#8211; Part &#8211; 1 of 2<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/vmlogger.com\/excel\/2017\/08\/vba-to-open-and-write-text-files\/embed\/#?secret=yXd3y2iFfa\" width=\"600\" height=\"338\" title=\"&#8220;VBA Guide to Interact with Text Files &#8211; Part &#8211; 1 of 2&#8221; &#8212; Let&#039;s excel in Excel\" data-secret=\"yXd3y2iFfa\" 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","thumbnail_url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/08\/All-About-TextFiles-VBA-Tutorial-3.jpg","thumbnail_width":800,"thumbnail_height":538,"description":"VBA to open Text file. VBA to write content in to text file. VBA to append content to text file. VBA to read text file. Write and Print statement in VBA."}