topic Re: We are getting issues in macros excel file using. in Qlik NPrinting

We are getting issues in macros excel file using.

01Nikita — Fri, 25 Jun 2021 05:01:52 GMT

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.

Re: We are getting issues in macros excel file using.

Lech_Miszkiewicz — Fri, 25 Jun 2021 05:46:05 GMT

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

Re: We are getting issues in macros excel file using.

Lech_Miszkiewicz — Fri, 25 Jun 2021 07:22:55 GMT

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

Re: We are getting issues in macros excel file using.

Ruggero_Piccoli — Fri, 25 Jun 2021 07:31:14 GMT

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

Re: We are getting issues in macros excel file using.

01Nikita — Mon, 28 Jun 2021 05:21:35 GMT

Hi All,

Thank you for response