topic Re: VB macro message box in AJAX in QlikView

VB macro message box in AJAX

Thu, 28 Apr 2016 21:12:12 GMT

Hi,

I have a macro that gets triggered via an Action Button. At the end of the macro a message box displays a message.

It works when executed from the Desktop client but the message box doesn't seem to work in AJAX.

The VB code is:

Sub MessageBox

vAnswer = MsgBox("Export Address Data Request Sent")

End sub

Should this work in AJAX? If No, what would be a good work around?

Thanks, Maria

Re: VB macro message box in AJAX

trdandamudi — Thu, 28 Apr 2016 21:45:30 GMT

Hope the below link will help you:

Macro on AJAX or IE Plugin

Re: VB macro message box in AJAX

marcus_sommer — Fri, 29 Apr 2016 07:25:47 GMT

Most macros won't work within the ajax-client but if it's only a message-box you could use a textbox with a variable within the visibility-condition for it and your button switched simply these variable.

- Marcus

Re: VB macro message box in AJAX

jerrysvensson — Fri, 29 Apr 2016 07:47:48 GMT

Marcus solution is the best. Your macro will actually stop running at the line where you have MsgBox.

Re: VB macro message box in AJAX

Colin-Albert — Fri, 29 Apr 2016 08:02:07 GMT

As marcus_sommer has suggested, using a variable and textbox is likely to be a better solution than a macro.

Not all macros are supported in the Ajax client and Actions can be used for many of the tasks you think would require a macro.

Have you read this blog in relation to macros & QlikView server? Macros are Bad