Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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



Reply
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
when opening an Excel Workbook, another blank workbook also opens Gord Dibben Excel Discussion (Misc queries) 0 October 12th 07 09:49 PM
when opening an Excel Workbook, another blank workbook also opens spmu Excel Discussion (Misc queries) 0 October 12th 07 01:46 PM
excel VBA problem - setting workbook as variable & opening/re-opening safe Excel Programming 1 August 20th 04 12:22 AM
How to make the opening of a workbook conditional upon the opening of another workbook Marcello do Guzman Excel Programming 1 December 16th 03 06:09 AM
How to make opening of workbook conditional of opening of another workbook turk5555[_2_] Excel Programming 2 December 15th 03 11:07 PM


All times are GMT +1. The time now is 11:20 AM.

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

About Us

"It's about Microsoft Excel"