Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default -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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compile error automation error nikkiws Excel Programming 0 January 17th 06 08:24 AM
RunTime Error (Automation Error) KD[_3_] Excel Programming 3 January 25th 05 01:56 PM
Automation Error `-2147221080(800401a8)` PB Excel Programming 0 September 3rd 04 03:00 PM
Automation Error, Unknown Error. Error value - 440 Neo[_2_] Excel Programming 0 May 29th 04 05:26 AM
Unknown where is the problem on the Runtime error - Automation error wellie Excel Programming 1 July 10th 03 08:12 AM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"