Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

Take out message when open qvw with macro

Hi Experts, how can take out the message when i open a qvw that contain macro code?

i created a macro to send email when the document open, this works fine and send the email if i entry to the document, but when i put in in the qmc, run ok but do not send the email.

what could be?

any idea?

thank you a lot

Fernando

4 Replies
fkeuroglian
Partner - Master
Partner - Master
Author

Attached an image

marcus_sommer

You could avoid the message if you allowed system access and enabled the small option below that the server shouldn't ask again.

While running tasks from server macros won't be executed. For this you could create an qvw which included an execute-statement which runs a batch, see here what is meant:

Is it possible to create a batch file in the Qlikview Script

QVW to create bat file which contain the copy command for all the QVD's used in the QVW

- Marcus

fkeuroglian
Partner - Master
Partner - Master
Author

Hi Marcus, thank you for your answer, but one question:

I put an execute comand in the script to start the .bat

the .bat call to what?

i want to call a macro to send mail only.

This is because i want to anounce when the last qvw form my qmc finish the reload.

thank you a lot

Fernando

marcus_sommer

The batch to call the qv fat-client which executed then the macro maybe per OnOpen trigger - see here an example for such a batch:

"C:\Program Files\QlikView\qv.exe" /R "D:\YourPath\YourApp.qvw"

- Marcus