VBA doesn't support accessing a closed workbook.

--
Regards,
Tom Ogilvy

"syaronc " wrote in message
...
Hi all,
I have VB function that sums cells by the font color in my workbook and
I use this function on a linked file in this way:

=SumFontColor($A$1,'C:\LOGISTICS\A4\[NEW BOOKING
SUMMARY.xls]N.BLDG'!E41)

For some reason all cells appear as "#value!" if the linked workbook is
closed
,if the linked workbook is opened all values appear as they should....


What am I doing wrong?

Please advise,
Thanks Yaron

p.s.

here is the above mentioned function:
Function SumFontColor(rFColor As Range, rFSumRange As Range)

Dim rFCell As Range
Dim iFCol As Integer
Dim vFResult

iFCol = rFColor.Font.ColorIndex

For Each rFCell In rFSumRange
If rFCell.Font.ColorIndex = iFCol Then
vFResult = WorksheetFunction.Sum(rFCell) + vFResult
End If
Next rFCell

SumFontColor = vFResult
End Function


---
Message posted from http://www.ExcelForum.com/