Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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