Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

macro for saving data from a notepad??

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

0 Replies