topic Run macro from server in QlikView

Run macro from server

Mon, 26 Jan 2026 18:19:17 GMT

Is there any way to have the Enterprise Manager run a macro when reloading a QV-document? I've tried setting up running of this macro with Task Scheduler on Windows Server 2008 but I can't get it to run properly without myself being logged in. Also it requires my account to be associated with a developer-license which is also undesirable. I'd like it to just run from the server. Is this possible?

Run macro from server

Mon, 31 Oct 2011 11:02:45 GMT

hi,

Wat u can do is write the macro in notepad n save it as .vbs file(vbscript). Then u can write a batch file to run this file.

Now at qmec u can include this batch file in external tasks.

Hope this helps.

Br,

Prasanna.

Run macro from server

Mon, 31 Oct 2011 12:25:26 GMT

Thanks for the reply.

My macro interacts with some of the components in the QV-document (performing various selections and such things). Will this work when run as external task? Will the API for QlikView still be available for VBScript-code that runs "outside" of the QV-document?

Run macro from server

Mon, 31 Oct 2011 13:03:14 GMT

hi,

what you need to do is to open the qlikview application in the macro in the vbscript. I think it shd work...but I'm not sure of it...

If it is ok 4 u to specify the req. it'll be helpful for me. But thats up to u to decide.

Br,

Prasanna.

Run macro from server

Mon, 31 Oct 2011 14:58:49 GMT

I did some alterations to my macro and I can now run it from a .vbs-file outside of QV. Thanks for the suggestion!

Now for my next question (and it might be a silly one), where in QMEC do configure external tasks? I can't find it anywhere.

Run macro from server

lhr — Mon, 31 Oct 2011 15:28:15 GMT

i believe it's system -> supporting tasks

Run macro from server

Mon, 31 Oct 2011 15:42:28 GMT

I find no "Supporting tasks"-option or tab under System. I'm using QlikView Server 10 btw.

Run macro from server

lhr — Mon, 31 Oct 2011 15:49:45 GMT

im sorry, i should have mentioned that the supporting tasks tab requires a publisher license.

Run macro from server

Mon, 31 Oct 2011 16:01:49 GMT

Ah, we don't have one of those yet

Run macro from server

Thu, 01 Dec 2011 09:52:36 GMT

I have exactly the same problem and have "Supporting Tasks" availaible. But how to write a VBScript to open a specific QlikView App, exporting data to an excel file and close the app?

At this moment i have a macro inside the app, but it works only when manually starting the macro "export":

sub export

call exportToExcel("tb1", "c:\excelfile_")

end sub

sub exportToExcel(objectId, filePath)

strText=FormatDateTime(Now(),2)

dim o

Set o = ActiveDocument.GetSheetObject(objectId)

o.ExportBiff filePath & mid(strText,7,4) & mid(strText,4,2) & mid(strText,1,2) & ".xls"

Set o = nothing

end sub

Thanks for your help!

Run macro from server

jerrysvensson — Thu, 01 Dec 2011 14:35:35 GMT

Check out this link

http://community.qlik.com/thread/37204

Solved our problems on windows 2008 server.

Run macro from server

Fri, 02 Dec 2011 06:47:05 GMT

Thanks for the Link, but it is not working anymore...

Run macro from server

jerrysvensson — Fri, 02 Dec 2011 07:21:41 GMT

Strange, it worked before..

This was what helped us: We created the Desktop folder.

To work, Office needs a Desktop folder (why? ... good question!).

And on Windows 2008 there is no Desktop folder if you are not logged in, so you have just to create one and it will work fine !

- Windows 2008 Server x64

Please make this folder.

C:\Windows\SysWOW64\config\systemprofile\Desktop

- Windows 2008 Server x86

Please make this folder.

C:\Windows\System32\config\systemprofile\Desktop

Next, to run the macro I use this command: qv.exe /vParam=1 /NoSecurity App.qvw

But I don't know if the /NoSecurity flag is really usefull"

Run macro from server

Wed, 14 Dec 2011 06:46:30 GMT

Thanks for your answer, i will try out that. The /NoSecurity Flag is needed when you use macros in your qlikview documents. Qlikview will not ask if macros are allowed and will open the document without any questions.

Run macro from server

Fri, 06 Jan 2012 08:03:27 GMT

Hi Jerry,

your idea really helped me.Now the external Programm works.

My *.bat File looks like this:

"C:\Program Files\QlikView\qv.exe" /NoSecurity "D:\QlikView\Program.qvw"

One really important thing: The Admin-User on the QlikView Server must have a licence! Otherwise QlikView will open with the personal edition and is not able to trigger macros on Open...

Regards, Martin

Re: Run macro from server

arieidel — Fri, 13 Dec 2013 15:53:59 GMT

Thanks, dj-kalle.

I've been dealing with exactly this problem for a few days and the key was: the QV service user has to have a licence!

Also, I had to create a Supporting Task in order to execute then .BAT file because it wasn't working through a .QVW file with EXECUTE sentence.

Re: Run macro from server

koresaket — Tue, 17 Feb 2015 11:27:33 GMT

Hi Prasanna,

I've created a vbs script file which accesses the QV document data to format a mail body and sends a mail. The vbs works properly wen triggered via command prompt. However i tried to trigger the vbs script via a batch file using a supporting task. Though the supporting task runs successfully, it doesn't trigger the vbs. (I don't receive any mail.) Does supporting task do not support this types of operations?

Re: Run macro from server

Peter_Cammaert — Tue, 17 Feb 2015 11:43:41 GMT

Supporting tasks support whatever you throw at them.

However your conclusion (not triggered because I don't get any email) may not be entirely correct. There are many possible points of failure in a black box-setup like this.

Does your vbs script output any logging information?

Re: Run macro from server

koresaket — Tue, 17 Feb 2015 12:32:24 GMT

Hi Peter, Thanks for the quick response.

I tried with a different vbs script which creates a simple .txt file (This vbs script doesnt interact with the Qlikview document). And that went through successfully when triggered using Supporting task via a batch file.

However my mailer vbs script doesnt seem to to go through successfully. (Please note this vbs script does work fine when triggered via command prompt.)

Since the only difference between these two vbs scripts is that the latter interacts with the Qlikview document, i concluded that the supporting task doesnt not support this.

In your opinion, should the supporting task support this operation? I'll dig in further to check if there's anything else causing the vbs operation to fail.

Re: Run macro from server

Peter_Cammaert — Tue, 17 Feb 2015 12:46:16 GMT

Yes it should, but that depends on how you interact with your QlikView document. If you use QV Desktop to do something with a document, remember that QV Desktop requires a license, and the service account that is running the supporting task probably has none.