Hi
I want to save the data in a notepad to a variable in qlikview using a macro.
I got the vbscript code to read the data in the notepad file.
"
Set objFileToRead = CreateObject("Scripting.FileSystemObject").OpenTextFile("C:\listfile.txt",1)
strFileText = objFileToRead.ReadAll()
objFileToRead.Close
"
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".
It is giving the following error
"
ActiveX component can't create object: 'Scripting.FileSystemObject'
"
Can someone help me where I am missing out?
or help me with code to save notepad data in a variable using macro