topic Re: Macro disabled in QlikView

Macro disabled

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

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.

Re: Macro disabled

jagan — Mon, 31 Aug 2015 03:05:28 GMT

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.

Re: Macro disabled

jagan — Mon, 31 Aug 2015 03:16:47 GMT

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.

Re: Macro disabled

jagan — Mon, 31 Aug 2015 03:19:57 GMT

Check this image

Re: Macro disabled

qlikviewwizard — Mon, 31 Aug 2015 03:40:10 GMT

Dear Jagan,

Thank you for the answers.

I am using vbscript in macro.

Failing at 13 line....

TestReport failed in sending.

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

Re: Macro disabled

jagan — Mon, 31 Aug 2015 03:46:59 GMT

Hi,

Do you have SendMailToAdmin() in your script?

Regards,

Jagan.

Re: Macro disabled

qlikviewwizard — Mon, 31 Aug 2015 03:53:34 GMT

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

Re: Macro disabled

jonathandienst — Mon, 31 Aug 2015 05:10:38 GMT

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

Re: Macro disabled

jagan — Mon, 31 Aug 2015 05:26:17 GMT

Hi,

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

Regards,

Jagan.

Re: Macro disabled

qlikviewwizard — Mon, 31 Aug 2015 06:19:03 GMT

Hi Jonathan and Jagan,

SendMailToAdmin function is there. Thank you.

Re: Macro disabled

jagan — Mon, 31 Aug 2015 06:21:31 GMT

Hi,

The If() is returning the false condition, because the file is not updated today, can you open the file and save it and run the macro again.

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

Re: Macro disabled

qlikviewwizard — Mon, 31 Aug 2015 06:24:24 GMT

Hi, Jagan,

Thank you for the info. I will test and let you know the results.