topic Re: Index on page loop excel in Qlik NPrinting

Index on page loop excel

amien — Wed, 03 Feb 2016 21:37:52 GMT

I have an excel template which contains a page loop. This loop will create alot of sheets.

Is it possible to create some kind of index sheet with a clickable link to the specific sheet?

Re: Index on page loop excel

amien — Mon, 08 Feb 2016 22:24:01 GMT

/Up .. this is not possible?

Re: Index on page loop excel

Daniel_Jenkins — Tue, 09 Feb 2016 07:54:21 GMT

Hi Amien,

NPrinting also supports Excel Macro Enabled Workbooks (.xlsm) so you can use VB script to achieve what you want.

I have attached a project that creates the following Excel file. A macro that creates the links is triggered whenever the file is opened. If the LINKS tab already exists it deletes it first.

When you click, say, F:

Extract to C:\Temp\Community\033 to preserve paths used or change them in the NSQ. Run the Task (task) to create the file. If you open the report template remember to preview as Xlsm:

HTH - Daniel.