Thanks. I'm trying to avoid mapped drives since this will be accessed by
many people from both internal and external (outside the company) machines.

I have just confirmed that this works in Excel 2003 using another computer
so it's got me *&%&*% why it's stopped working in 2007. Further help would
be appreciated.

H