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.
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.
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
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.
Thank you for the answers.
I am using vbscript in macro.
Failing at 13 line....
TestReport failed in sending.
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)
call SendMailToAdmin("TestReport failed in sending")
Here is the part of the script.
Function SendMail2(Result, Subject)
EmailSubject = subject
Const EmailFrom = "Testing"
Const EmailFromName = "Admin"
Const EmailTo = "email@example.com"