-2147221080 800401a8 Automation error
 

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

-2147221080 800401a8 Automation error
 

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

--
Regards,
Tom Ogilvy



"JoanExcel" wrote:


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
Erica


--
JoanExcel
------------------------------------------------------------------------
JoanExcel's Profile: http://www.excelforum.com/member.php...o&userid=35198
View this thread: http://www.excelforum.com/showthread...hreadid=549621