Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
01Nikita
Partner - Contributor III
Partner - Contributor III

We are getting issues in macros excel file using.

Hi All,

We are getting issues in macros excel file using. When we save the file with macros enabled and next time open the file in Nprinting designer the macros file gets deleted automatically. Please check and suggest. 

Labels (2)
2 Solutions

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

https://www.youtube.com/watch?v=VIq_MtTpBL8

just to ensure you follow 1 of 2 options of importing template please make sure you use steps from video above

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Ruggero_Piccoli
Support
Support

Hi,

Remember also that macros are never executed, only copied from the .xlsm template to the .xlms generated reports. So you also must select .xlsm as output format and trigger the execution on opening or ask to the recipient to execute them. If you create macros that change the appearance and select PDF as output it will not include the appearance modifications made by the macros because they are never executed. 

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

4 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi , you have to create xlsm excel file in excel with the macro and use it as a template when creating report.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

https://www.youtube.com/watch?v=VIq_MtTpBL8

just to ensure you follow 1 of 2 options of importing template please make sure you use steps from video above

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Ruggero_Piccoli
Support
Support

Hi,

Remember also that macros are never executed, only copied from the .xlsm template to the .xlms generated reports. So you also must select .xlsm as output format and trigger the execution on opening or ask to the recipient to execute them. If you create macros that change the appearance and select PDF as output it will not include the appearance modifications made by the macros because they are never executed. 

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
01Nikita
Partner - Contributor III
Partner - Contributor III
Author

Hi All,

Thank you for response