Finding what if IE or Excel is opening a workbook

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
 
P

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to open a workbook when application excel is running ? 4
Excel is removing Macros from workbook 3
help please 5
Way to change or update the macro 1
Opening a list of Excel files and run a macro in each 17
How maximize open excel workbook 1
Macro to delete part of a macro 1
Excel application main window background 3

Top