topic Re: Syntax Error in QlikView

Syntax Error

Tue, 24 Jul 2012 21:42:46 GMT

Can anyone help fix the syntax on this macro? If the answer=6, then I want to run the macro called "format".

sub ShowPopup

Answer=MsgBox("Do you want to export search results to Excel?",4,"Export Search Results")

If Answer=6 Then

Run "format"

Else

Exit Sub

End Sub

Re: Syntax Error

MayilVahanan — Tue, 24 Jul 2012 21:47:58 GMT

HI,

Sub ShowPopup

x=MsgBox("Would you like to export search results to Excel?",4,"Export Excel")

if x = 6 Then call exportToExcel("CH01", "C:\Export.xls")

End Sub

Re: Syntax Error

Tue, 24 Jul 2012 21:49:48 GMT

Instead of exporting to Excel in the Macro, what would the syntax be to just run the macro called "format"? Sorry, the question in the message box was misleading.

Re: Syntax Error

MayilVahanan — Tue, 24 Jul 2012 21:56:39 GMT

Hi,

Use like this,

Call Format() or call Format

Hope it helps

Re: Syntax Error

Tue, 24 Jul 2012 22:08:30 GMT

Thanks!!