topic macro for saving data from a notepad?? in QlikView https://community.qlik.com/t5/QlikView/macro-for-saving-data-from-a-notepad/m-p/688809#M1081561 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to save the data in a notepad to a variable in qlikview using a macro.</P><P></P><P>I got the vbscript code to read the data in the notepad file.</P><P></P><P>"</P><P>Set objFileToRead = CreateObject("Scripting.FileSystemObject").OpenTextFile("C:\listfile.txt",1)</P><P>strFileText = objFileToRead.ReadAll()</P><P>objFileToRead.Close</P><P>"</P><P>Here when I am just trying this particular peice of code to start with, it is giving me error in creating the object "Scripting.FileSystemObject".</P><P>It is giving the following error</P><P>"</P><P>ActiveX component can't create object: 'Scripting.FileSystemObject' </P><P>"</P><P>Can someone help me where I am missing out?</P><P>or help me with code to save notepad data in a variable using macro</P></BODY></HTML> Tue, 01 Jul 2014 13:26:07 GMT Anonymous 2014-07-01T13:26:07Z macro for saving data from a notepad?? https://community.qlik.com/t5/QlikView/macro-for-saving-data-from-a-notepad/m-p/688809#M1081561 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to save the data in a notepad to a variable in qlikview using a macro.</P><P></P><P>I got the vbscript code to read the data in the notepad file.</P><P></P><P>"</P><P>Set objFileToRead = CreateObject("Scripting.FileSystemObject").OpenTextFile("C:\listfile.txt",1)</P><P>strFileText = objFileToRead.ReadAll()</P><P>objFileToRead.Close</P><P>"</P><P>Here when I am just trying this particular peice of code to start with, it is giving me error in creating the object "Scripting.FileSystemObject".</P><P>It is giving the following error</P><P>"</P><P>ActiveX component can't create object: 'Scripting.FileSystemObject' </P><P>"</P><P>Can someone help me where I am missing out?</P><P>or help me with code to save notepad data in a variable using macro</P></BODY></HTML> Tue, 01 Jul 2014 13:26:07 GMT https://community.qlik.com/t5/QlikView/macro-for-saving-data-from-a-notepad/m-p/688809#M1081561 Anonymous 2014-07-01T13:26:07Z