In a message dated 2009.10.21 07:46 -0500, UDYADBHANU wrote:
I have a doubt on excel that I would like to reflect all the files that are in a particular folder on the excel sheet, I almost made it but I couldn't trace it out the problem where persists. I would like to do something that if a particular file not found that will shown on that cell as *0* and if found as *1*.
To clarify: cells in columns I, J (and upward) will contain file references; if the file exists, the cell should display 1; if not exist, 0. Is that correct?
Assuming yes, my first question [which I'm sure someone on the list can answer] is whether Calc finds the function ISERROR(HYPERLINK(<filespec>;..)) meaningful. From a quick test, I think not. That is, I don't think HYPERLINK() returns an error, whether the link is valid or not.
John --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
