-2147221080 800401a8 Automation error

[JoanExcel]

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

 

[Guest]

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