Creating a VBScript for EDX

[#1]

Hi All,

I am very new to QlickView, I have vast experience in using Business Objects but this is my first assignment with QlikView. We are upgrading to QV11 and one of the hurdles I am facing is to update the report "Reload" button which executes a "Task" in QV10. Apparently from reading blogs and community articles I have realized that there are a few .NET C# based resolutions; however in my case we don't want to use that route. So any pointers or any guide with this would be really helpful.

Regards,

Nitin

[#2]

Hi Fernando,

Sorry I can't give you points as it is not my post!

But, I have mentioned it in another post and marked it as solved

so that it could be helpful to others.

http://community.qlik.com/message/297650#297650

Regards,

Anju

[#3]

Hi Fernando,

Is there any way to fetch this path dynamically?

C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe

-Anju

[fosuzuki]

Anju,

I didn't understand you. Why would you need this?

[#5]

Fernando,

So, that I can use a variable in the command

strCommand = chr(34) & "C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe"  & chr(34) & _

" -r=" & chr(34) & "D:\DICE\PSReports\reloadvictim.qvw" & chr(34)

instead of hard coding it.

[#6]

Also,

Set WSHShell = CreateObject("Wscript.Shell")

    vSubText = ActiveDocument.Name

    WSHShell.popup vSubText

The popup displays '\share\reloadvictim.qvw'

I was expecting 'D:/share/reloadvictim.qvw'

Could you help me the function please?

[fosuzuki]

But the path C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe will never change, so you don't need it dynamic...

[fosuzuki]

Try ActiveDocument.GetPathName

[#9]

Hi Fernando,

In a scenario, where I try to execute this macro where the server is on one machine and client on another, then the macro fails.

I guess it is trying to execute the command on the client ..?

strCommand = chr(34) & "C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe"  & chr(34) & _

" -r=" & chr(34) & "C:\QlikViewMount\reloadvictim.qvw" & chr(34)...

how can I make it pick the server path?

Thanks and Regards,

Anju

[#10]

This is the error that I get..

Error: SQL Error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

1/11/2013 2:17:50 PM:       SQL State:IM002

1/11/2013 2:17:50 PM:       General Script Error

1/11/2013 2:17:50 PM:       Execution Failed

1/11/2013 2:17:50 PM:      Execution finished.

[fosuzuki]

This error is related to a missing ODBC, it has nothing to do with the macro code.