Working application - Now generates error

30 May 2005 5:30 AM

Madiya

I had an working macro application which integrates our intranet data
into excel sheet by using internet explorer. It was working fine till
few 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")

BUT application runs fine if I launch IE manually before starting my
application.

I hope somebody can help me here.
Thanks
Madiya

30 May 2005 5:51 AM

Michael Cole

Madiya wrote:

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

If this is in Excel, then perhaps microsoft.public.excel.programming may be
a better group to ask in.

--
Regards,

Michael Cole

30 May 2005 7:28 AM

Madiya

Thanks to reply.
Well, I have tried it both (in VB6 as well as Excel VBA). The problem
is same. Both works fine if I launch IE manually before running my
application. I had posted it in microsoft.public.excel.programming but
got suggestion to post in MSIE groupe. I thought vb group is better as
it directly concerns VB (application is written in VB6) as well as
automation.

Regards,
Madiya.

Michael Cole wrote:
Show quoteHide quote

> Madiya wrote:
> > I had an working macro application which integrates our intranet data
> > into excel sheet by using internet explorer. It was working fine till
> > few days back but now generates error as below.
>
> If this is in Excel, then perhaps microsoft.public.excel.programming may be
> a better group to ask in.
>
>
> --
> Regards,
>
> Michael Cole