Hi all,
My aim is to retrieve a data value from an external Excel document
using VBA. I have an external document available at C:\src.xls. This
contains a cell with the text "PM Ckpt to CRF finish " and this text
is unique. I need the number value 4 rows down and 2 columns across
from that cell. This data can then be assigned to a long variable
"complete". I have no issues with hard coding the location of the
file src.xls. Can somone give me any direction on how this can be
done?

Many thanks in advance

Khurram