Ok, used your macro and moved the other two files into the right places.



When I run it, this pops up in yellow;

CN.Open ConnectionString:="Provider=Microsoft.ACE.OLEDB.12 .0;" & _
"Data Source=" & strWorkbook & ";" & _
"Extended Properties=""Excel 12.0 Xml;HDR=YES"";"

I think there is something I need to enable for this to work?

You probably don't have the Office 2010 database engine - see https://www.microsoft.com/en-us/down....aspx?id=13255

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

You're right I didnt.

I do now and a different error comes up.

Gonna park this for a little while while I work on something else which i'm nearly there with and is less complicated.

Thanks for your help so far.