Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

filename and path with visual basic

Hey guys,

this is my first post in this forum. In the past I have already found many solutions here. Many thanks to these sites.

But for me the time has come where I need to ask you for advice.

Unfortunately I have no knowledge of programming in Visual Basic. What I would like to achieve is the file name and the path to the *.qvw.

I hope you can help me. Thank you in any advance.

P.S. Of course I have first the forum every effort to find an answer, unfortunately without success.

Regards,

Christian.

1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Re: filename and path with visual basic

You can store the document name and path in variables in your load script.

Ex: Let vDocName = DocumentName()

Then you can reference the variable in VB.

View solution in original post

4 Replies
mwoolf
Honored Contributor II

Re: filename and path with visual basic

No VB is required. Look at the DocumentName and DocumentPath system functions.

MVP
MVP

Re: filename and path with visual basic

Hi

You may not need script for this. Use DocumentName() or DocumentPath() for the file name and path name of the qvw file.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: filename and path with visual basic

Thanks for your fast response. It seems not so easy for me.

Now i write for test following lines in an VB Script:

  • msgbox(ActiveDocument.DocumentName)
  • msgbox(DocumentName())

Nothing like that worked so far. That can not really be so difficult, I thought.

Any other spellings?

mwoolf
Honored Contributor II

Re: filename and path with visual basic

You can store the document name and path in variables in your load script.

Ex: Let vDocName = DocumentName()

Then you can reference the variable in VB.

View solution in original post