I have built a drill down that links to an excel file. The file changes every day. However, on some days the file does not exist and I need to turn off the link. (I get the http 404 error).

I do not have direct access to the actual file since not on a server I can reah directly.

How can I turn off the link when the file is not there?

Fernando

If a tree falls in a forest and no one is around to hear it, does it make a sound?

"The file changes every day. However, on some days the file does not exist "

can you just make the file empty insted of deleting it?

JasonK...if its a FOCUS file,
then
CREATE FILE filename NEW
should do the trick for you.
give it a whirl.

Fernando, here's the way i do it.
the STATE command gives a return code of 0 if its there and i-forget-what-but-not-0 if its NOT there...
CMD STATE d:\...\myfile.xls
-RUN
-SET &comment = IF &RETCODE IS 0 THEN ' ' ELSE '-*';
...now in my fex...
&comment.EVAL TYPE=DATA,COLUMN=FRED,FOCEXEC=fexanme(..),$

so the comment is blank if all is well.
and the comment is -* if all is not well.

works for me...
give it a try.

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

Since Fernando "does not have direct access to the actual file since it's not on a server he can reach directly" how can any of this work?

hmmm.
all i can think of is
FILEDEF thatfile DISK \\servername\drive\dir\thatfile.xls
before the STATE bits.
If \\servername isn't on his network, then telepathy might work.

Is the Excel file in the drill down created in a focexec? If it is add "ON TABLE SET EMPTYREPORT ON" and it will create an empty spreadsheet with nothing but the headings. If it is created some other way there are usually server commands that you can check to see if it exists, what operating system are you on?