Macro disabled

[qlikviewwizard]

Hi All,

I am getting a message Check if the macro has been disabled.I want to enable the macros used in my qvw application. How to check. Please help to give steps.

Thanks in advance.

[jagan]

Hi,

Where you are getting this error?

Try like this

Press Ctrl + M -> and set below options

Requested Module Security ->  System Access

Current Local Security -> Allow System Access

Regards,

Jagan.

[jagan]

Also check this in Qlikview server

QMC -> System -> Setup -> Click on Qlikview Server -> Security -> Select Allow Macro Execution on Server & Allow unsafe macro execution on server options.

Hope this helps you.

Regards,

Jagan.

[jagan]

Check this image

[qlikviewwizard]

Dear Jagan,

Thank you for the answers.

I am using vbscript in macro.

Failing at 13 line....

TestReport failed in sending.

d

VBScript:

dim test
dim subject2

subject2 = "TestReport"
Set objFSO = CreateObject("Scripting.FileSystemObject")
set objFile = objFSO.GetFile("C:\QlikviewReports\TestReport.xlsx")
test = "  - Last Updated on: " & objFile.DateLastModified


if objFile.DateLastModified > cdate((date()) &" 12:00:00 AM")  then ' (CDate(now)-1)  then
  call SendMail2(test, subject2)
else
  call SendMailToAdmin("TestReport failed in sending")
End if

[jagan]

Hi,

Do you have SendMailToAdmin() in your script?

Regards,

Jagan.

[qlikviewwizard]

Yes.

Here is the part of the script.
Function SendMail2(Result, Subject)
EmailSubject = subject
Const EmailFrom = "Testing"
Const EmailFromName = "Admin"
Const EmailTo = "qlikviewtest@gmail.com"
Dim StrHTML

[jonathandienst]

Yes, but you also need a function SendMailToAdmin().

[jagan]

Hi,

Do you have this SendMailToAdmin()  macro in your QVW file?

Regards,

Jagan.

[qlikviewwizard]

Hi Jonathan and Jagan,

SendMailToAdmin function is there. Thank you.