LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 239
Default Working application - Now generates error

I had an working macro application which integrates our intranet data
into excel sheet by using internet explorer. It was working fine till 3
days back but now generates error as below.

Runtime error'-2147024894 (80070002)':
Automation error
The system can not find the file specified.
The buttons are End, Debug, Help.

This happens on the very first statement which is below.
Set ie = CreateObject("InternetExplorer.Application")

Macro do not refers to any file atall. It creates a new workbook with a
new sheet. But thats after getting the data from intranet.

I dont understand why it breaks after running successfully from last
6months(may be more then that)

Any help is appreciated.

Regards,

 
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
Hyperlink selection generates error message cwpauline Links and Linking in Excel 2 October 18th 08 04:04 AM
Excel Analysis Add-in EOMONTH generates #NAME? error Ray Excel Worksheet Functions 6 July 18th 05 07:00 PM
setting ThrottleInterval generates Run-Time error Marc Deveaux[_2_] Excel Programming 0 July 7th 04 04:56 PM
Find generates error message James Houston Excel Programming 3 April 28th 04 07:55 AM
Copy generates an automation error. Richard[_24_] Excel Programming 1 January 16th 04 12:37 PM


All times are GMT +1. The time now is 08:30 AM.

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

About Us

"It's about Microsoft Excel"