On 15 Jul, 14:32, Keith74 wrote:
You're trying to reference a closed workbook?
Your filename\path is wrong?
Your syntax for the filename\path is wrong?

code examples help.

Thank you,

Yes the workbook is closed. Further tests found if I open the
workbook and re-save it, the workbook in which the data is to be
imported to does not error. I suspect the application exporting the
data might be exporting an older version of excel.

I'll let you know if this is not the case.