Finding what if IE or Excel is opening a workbook
 

I made a macro that seems to work great. Then one day I found when Internet
Explorer tried to open a workbook without a excel application being open I
got a fatal error.

Is there some code(s) to find out if internet explorer is trying to open a
wookbook?
And
Is there some code(s) to find out if Excel application is running?

Because when I have a excel application open Internet Explorer will open a
wookbook without any problems.

Thanks in advance

Finding what if IE or Excel is opening a workbook
 

Normally IE should be able to open a workbook without Excel already running.
I can only assume there is something unusual with your overall scenario but
I have no idea what.

If there are no running instances of Excel when IE attempts to load a
workbook, a new invisible instance is created, sounds like something is
going wrong when IE starts this new instance.

Try experimenting with a very simple workbook and code.

Regards,
Peter T



"Still_learning" wrote in message
...
I made a macro that seems to work great. Then one day I found when Internet
Explorer tried to open a workbook without a excel application being open I
got a fatal error.

Is there some code(s) to find out if internet explorer is trying to open a
wookbook?
And
Is there some code(s) to find out if Excel application is running?

Because when I have a excel application open Internet Explorer will open a
wookbook without any problems.

Thanks in advance