this is the site.
http://groups.google.com/groups?hl=e...el.programming
You can search for your post there.
Here's the post.
It's not important that you know why. It's only necessary that you kno
that
this is so. You can't reference closed workbooks except using literal
external reference links, like
'C:\foo\[bar.xls]Junk'!$X$99
in worksheet cell formulas or using the ExecuteExcel4Macro method o
the
Application class, and that won't work in functions called as udfs. Th
only
work-around is creating another Application instance, and calling the
ExecuteExcel4Macro method in that instance.
Also, if you used the same reference syntax in your function as you us
in
SUM, you'd find they both either work or both return the same error.
Charle
--
Message posted from
http://www.ExcelForum.com