Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
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.
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.
