Thread: -2147221080 800401a8 Automation error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default -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


Reply With QuoteReply With Quote