Ian's Excel Add-in Ribbon Menu

Page Reference

  • rudiperold
  • Topic Author
  • Visitor
  • Visitor
19 Apr 2018 15:24 #1 by rudiperold
Page Reference was created by rudiperold
Thanks Ian for developing such an easy and quick way to import an ASCII file to Excel. Just one question. When I do the import with the Add-in, it only import the item number and not the page number as well. Is there something I am doing wrong or can I ask that the Add-in be upgraded to import the page reference as well as page number to Excel spreadsheet. Thanks again.

Please Log in to join the conversation.

More
19 Apr 2018 15:35 #2 by Ian
Replied by Ian on topic Page Reference
Hi Rudi,

I am glad that you are finding my addin useful.

When importing the ASCII file, ensure that the "Retain WinQS Codes" box is ticked. This retains all of the WinQS references (ISC number, section number, etc.) in hidden columns once the file is imported into Excel. Unhide the required columns as required.

Let me know if you need any additional info to resolve your query.

Regards,
Ian

Please Log in to join the conversation.

  • rudiperold
  • Topic Author
  • Visitor
  • Visitor
19 Apr 2018 15:41 #3 by rudiperold
Replied by rudiperold on topic Page Reference
Thanks Ian. Did not see the hidden columns though. That helped. Thanks again.

Please Log in to join the conversation.

More
19 Apr 2018 16:37 #4 by Ian
Replied by Ian on topic Page Reference
It's a pleasure, glad you've come right.

I'll add a note next to the tick box on the import screen stating that the WinQS codes are in hidden columns in the Excel file.

Please Log in to join the conversation.

Powered by Kunena Forum
We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.