"AA" wrote in message
...
{='c:\mywb.xls'!myRange} reads the area myRange into the
current worksheet when entered as an array formula in an
identical area. However, this does not retrieve the format
of the cells from c:\mywd.xls.

Is there a way of getting the data with the format?

You can do it in VBA code, using pastespecial and xlPasteFormats. I don't
think it is possible to it as a worksheet function