On Mon, 17 Oct 2005 01:46:48 +0200, Laurent Longre
wrote:


Harlan, Ron, Reinhardt,

Harlan Grove a écrit :

When you enter a cell formula interactively or via macro, if that
formula contains token that are syntactically external reference links
but the workbook and worksheet combination doesn't exist, Excel
*ALWAYS* displays a dialog prompting you to choose another workbook or
worksheet. AFAIK, there's no way to disable these dialogs.

I agree with you.

I finally got around this in my own pull udf by using
ExecuteExcel4Macro method calls, which don't cause these dialogs to
display when either workbook or worksheet don't exist. Looks like
Laurent Longre's INDIRECT.EXT retrogressed from earlier versions.

Indeed. I didn't remember this problem. :-(

The bug is fixed now, the next version will come soon (with a lot of new functions!)

Cordially,

Laurent

Thank you for that. Much appreciated

--ron