Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


S T

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...