read the input of a .txt file into a variable in my vba macro script

[#1]

Hi @All,

i want to read the input of a .txt file into a variable in my vba macro script.

In line 2 the fso Object is empty ? I don't know why ? So the rest of my script can' work, because i need the fso Object

1. fso = CreateObject("Scripting.FileSystemObject")
2. 'msgbox ("FSO: " & fso)
3. 'dateipfad = "path_and_name.txt"
4. 'fsoFile = fso.opentextfile(dateipfad, fsoForReading)
5. 'inhalt = Split(fsoFile.ReadAll, vbCr)
6. 'inhalt = fsoFile.ReadAll
7. 'msgBox(inhalt)
8. 'fsoFile.Close
9. 'fsoFile = Nothing

[#2]

Try

SET fso = CreateObject("Scripting.FileSystemObject")

Object assignment needs the SET operator

[#3]

I have set the Set operator before, but it also doesn't work.

I'm testing it at the moment wit the set operator, but it also doesnt' work.

[tresesco]

Creating object is like creating a placeholder. Unless it holds something magbox would not probably be able to show that. Try without those message boxes.

[#5]

Alternatively, you can read the file in the Qlikview LOAD script in stead of in a macro.

If you do need the value in a macro you can access the script variable like this

set MyVar = ActiveDocument.Variables("vName")

[jerrysvensson]

Have you tried changing the security settings in the macro dialog to Allow system Access?
Or are you trying to achieve this outside QV?

[#7]

yes the script runs with Allowing system Access

[#8]

I have tried without msgBox, but it also doesn't work

[#9]

Do you have maybe an example or tutorial, where i can read a txt file into a variable in vba macro of qlikview. Because i have the experience, that the vba macro is not the same as the "normal" vba language.

[#10]

First in your LOAD script read the file and assign the value to a variable (I assume the file has just 1 value)

LOAD @1
FROM
C:\Temp\myvar.txt
(txt, codepage is 1252, no labels, delimiter is '\t', msq);

Let vVar = Peek('@1', -1);

Next, in your VBScript macro you can read the Qlikview variable:

Function GetVar
  set MyVar = ActiveDocument.Variables("vVar")

  'add your stuff here
End Function

Remember to always see if you really need a macro, you'd be amazed what you can accomplish with the - more robust and manageable - Qlikview load script.

By the way

the vba macro is not the same as the "normal" vba language.

Qlikview does not use VBA, it is VBScript. A small but essential difference!