topic Re: VB macro in QlikView - import VB packages in QlikView

VB macro in QlikView - import VB packages

Anonymous — Thu, 29 Jan 2015 10:01:53 GMT

Hi all,

I need to find out the working directory from which my QlikView VB macro is running.

According to MSDN, this should suffice:

Imports System

Imports System.IO

Dim path As String = Directory.GetCurrentDirectory()

The thing is that QV doesn't recognize the Imports or Directory.

Any clue how to import VB packages in QlikView? I'm sure there are also other cases where it can be useful.

Thanks,

Assaf

rubenmarin — Thu, 29 Jan 2015 10:34:08 GMT

Hi Assaf, so far I know there is no 'Imports' Statement in vbscript, 'Imports' is a Visual Basic statement.

Not sure if the CreateObject statement can help you, for a qlikview macro you need to search for vbscript (or JScript)

jerrysvensson — Thu, 29 Jan 2015 10:39:47 GMT

That is VB .Net not vbscript.

vbscript is what is used in QlikView.

Try to google: vbscript current directory

Anonymous — Thu, 29 Jan 2015 11:45:59 GMT

Thanks Jerry, your reply put me on the right tracks.

This is the answer:

Dim WshShell, strCurDir Set WshShell = CreateObject("WScript.Shell") strCurDir = WshShell.CurrentDirectory