The SAS Output Delivery System and reporting techniques

ExcelXP ToC

Reply
Super Contributor
Posts: 359

ExcelXP ToC

I am creating an excel spreadsheet with a Table of Contents. I get the full URL of the location where I created the file as the link rather than just the sheet name.
Since this file is portable the links do not work. Can this be changed?
SAS Super FREQ
Posts: 8,743

Re: ExcelXP ToC

Hi:
When I use the contents= suboptions, as described here:
http://support.sas.com/forums/thread.jspa?messageID=17739䕋 (code example is in the middle of the post).

I get links to each sheet. Are you using TAGSETS.EXCELXP and the contents= suboption?

cynthia
Super Contributor
Posts: 359

Re: ExcelXP ToC

I got the ToC to work. The Index does not. The example helped.

Thanks
Ask a Question
Discussion stats
  • 2 replies
  • 194 views
  • 0 likes
  • 2 in conversation