Hi,
I need to add a footer in EXCEL format saying -
Please click HERE
When the user clicks on 'HERE', a new window link should open to www.yahoo.com.
My code is like -
Footer
"Please click <+0>HERE <+0>"
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLOR='BLUE',
STYLE=UNDERLINE,
TARGET='_BLANK',
URL=http://www.yahoo.com,
$


In excel the spot marker is not working and the whole line get underlined.Please suggest.

I suspect that the footing is a single merged cell.

try using HEADALIGN=BODY, and COLSPAN in the styling

This does not work...any other way?

How would SET BASEURL work?

You do need to split the two parts of the footing into two, one for the normal text and one for the link-text. This is an excel requirement, because excel can only put hyperlinks on entire cells, not on parts of the contents of one cell.
So JG's solution is correct.
The last part of the procedure would look something like this:

FOOTING
"Please click <+0>HERE"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
     HEADALIGN=BODY,
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     COLOR='BLUE',
     STYLE=UNDERLINE,
     TARGET='_BLANK',
     JUSTIFY=LEFT,
     URL=http://www.yahoo.com,
$
ENDSTYLE

Hope this helps ...

B_B

Could you post a fuller example of the code
What you have shown is totally sytactically incomplete and incorrect.

what is needed as a minimum is on ON TABLE and everything in the style sheet section