Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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