I have followed this previous topic and created a link in ex...

[S T]

I need the following code to work for EXL07

-SET &ECHO=ALL;

-* File LinkXL.fex

SET COMPOUND = OPEN

 

TABLE FILE CAR

PRINT

COMPUTE CTYLINK/A50 = '<a href="#''' || COUNTRY || '''!A1">' || COUNTRY || '</a>' ;

ON TABLE PCHOLD FORMAT EXL07

ON TABLE SET STYLE *

TITLETEXT='Countries', $

ENDSTYLE

END

 

SET COMPOUND = BYTOC CLOSE

DEFINE FILE CAR

PG1/A50='<a href="#''Countries''!A1">' || 'Countries' || '</a>' ;

END

 

TABLE FILE CAR

PRINT CAR MODEL

BY COUNTRY

FOOTING

"<PG1 "

ON TABLE PCHOLD FORMAT EXL07

END

[Douglas Lee 2]

Thanks But, am I missing something here My result shows the links as text, not links

[S T]

Yes, If you substitute EX07 with EXL2k , it works. But I need to work for EXL07

[S T]

I have followed this previous topic and created a link in excel successfully to a Tab with in the report. However this link does not work when I use EXL07 format. Is there a way to link from one tab to another in EXL07 or XLSX formats

[sOLVED] Creating a Hyperlink that References Another Tab from within an Excel Workbk

[David Beagan]

How about this:

SET COMPOUND = OPEN

TABLE FILE CAR

PRINT COUNTRY

COMPUTE CTYLINK/A50 = '#''' || COUNTRY || '''!A1'; NOPRINT

ON TABLE PCHOLD FORMAT EXL07

ON TABLE SET STYLE *

TITLETEXT='Countries', $

TYPE=DATA, COLUMN=N1, URL=(CTYLINK), $

ENDSTYLE

END

 

SET COMPOUND = BYTOC CLOSE

TABLE FILE CAR

PRINT CAR

MODEL

COMPUTE PG1/A50='#''Countries''!A1'; NOPRINT

BY COUNTRY

FOOTING

"Countries"

ON TABLE PCHOLD FORMAT EXL07

ON TABLE SET STYLE *

TYPE=FOOTING, URL=(PG1), $

ENDSTYLE

END