Finding what if IE or Excel is opening a workbook

  • Thread starter Thread starter Still_learning
  • Start date Start date
S

Still_learning

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
 
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
 
Back
Top