When I post the code

Name sourceWB.path as "D:\Data\" & sourceWB.name

I get the following error.

-2147221080 800401a8 Automation error

I have checked the file and folder and neither are "read only"

Does anyone know what this error means?

Thanks
Eric

--
JoanExce
-----------------------------------------------------------------------
JoanExcel's Profile: http://www.excelforum.com/member.php...fo&userid=3519
View this thread: http://www.excelforum.com/showthread.php?threadid=54962