Check Refresh Status of External Data Query

[Mark]

Hi -

I'm automating an excel 2007 workbook. The workbook connects to an OLAP
server using Cube functions.

How can I check the refresh status of External Data query (Cube function) to
the OLAP cube?

Thanks,
Mark