-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
Erica

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
>
>

Hey,

after reading through your pages, I now signed up and found a similar problem to Joan. Would be great if you guys can help me.

Please Login or Register  to view this content.

It shows the Automation Error for the line with n = ...