Does anyone know the syntax for creating a hyperlink in a mult-tab Excel report that can reference another one of the tabs in the Excel workbook, if this can be done?
For example, I want to create an Excel report that opens into a workbork (with multiple tabs). I want to create a hyperlink on the first tab that can reference another tab within the workbook.

This message has been edited. Last edited by: MCKELPA99,

I posted a solution to this only a couple of weeks ago

A page from Waz's notebook!

  
-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 EXL2K
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 EXL2K
END

Waz, thanks for your reply. Can you please repost your solution or let me know what I should search for to find it.

Waz, I see that Danny-SRL has posted it. I will test it.

You know, its posted in the forum.

A quick search for "hyperlink" and "excel" would have given you the original post.

My test of it works fine. Thanks for your help.