topic Re: Defining Variables outside a Sub (marco variable) in QlikView

Defining Variables outside a Sub (marco variable)

Wed, 13 Jul 2016 15:16:03 GMT

Hi all,

Is it possible to define a variable, to be used in sub / macro?

I have a file path hardcoded in a macro, but if I want this to change, I don't really want to search the script for all instances of it.

I know in SAS, SQL etc...I can use a macro variable & state it at the top. Is this possible with VBScript?

Something like this I want to do:

FilePath = C:\user\document\pictures

Sub

dim fso
Set fso =CreateObject("Scripting.FilesystemObject")
fso.CreateTextFile "FilePath\dummy.txt"

End Sub

tamilarasu — Wed, 13 Jul 2016 16:07:18 GMT

Hi Jammy,

Create a variable in front end and assign the variable in inputbox. You can change the path whenever required,

You can use below code to fetch the path from front end variable.

Sub Test

Dim fsoh

FilePath = ActiveDocument.GetVariable("vPath").GetContent.String

FileDate = ActiveDocument.Evaluate("date(Now(), 'DDMMYYYY hhmmss')")

If Right(FilePath,1)<> "\" then

FilePath = FilePath & "\"

End If

Set fso =CreateObject("Scripting.FilesystemObject")

fso.CreateTextFile FilePath & "dummy_" & FileDate & ".txt"

End Sub

Sample attached fro your reference.

tamilarasu — Wed, 13 Jul 2016 16:24:21 GMT

If you want to hardcode the path use below code.

FilePath = "C:\user\document\pictures"

Sub Test

Dim fso

Set fso =CreateObject("Scripting.FilesystemObject")

fso.CreateTextFile FilePath & "\Dummy.txt"

End Sub

Wed, 13 Jul 2016 22:18:13 GMT

Thank you..... perfect solution & I got it working!