topic Re: QWV path in VBScript in QlikView

QWV path in VBScript

azimabadi — Thu, 19 Apr 2012 08:07:41 GMT

Hi all,

i need to get the path of QVW file in my module.

in script, i can call DocumentPath to retrive the path, but in VBScript this will not work.

There is a object.Path in VBScript syntax but i need to initialize the object first.

Anyone has an idea how can i get the path?

Regards

Peyman

Thu, 19 Apr 2012 08:37:34 GMT

Here is the snippet for Active QVW Path and File Name in VBS, got it from API Guide:

Sub showPath

msgbox(ActiveDocument.GetPathName)

End Sub

Thanks,

Narasimha

azimabadi — Thu, 19 Apr 2012 09:44:59 GMT

to retrive only path :

tmpPath = ActiveDocument.GetPathName

lastBackSlash = InStrRev( tmpPath , "\" )

path = Left( tmpPath , (lastBackSlash - 1) )