Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Languages / Managed C++ / May 2004

Tip: Looking for answers? Try searching our database.

hard to open excel while debugging

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rudy Ray Moore - 10 May 2004 23:48 GMT
Anybody notice that while debugging, excel (and some other apps) have a
"hard time" opening?  Anybody know why this is?

"hard time" - takes 20 seconds to open, low CPU usage.

I'm using VC++ .net/2003/7.1, native code.

Rudy
Julie - 11 May 2004 00:12 GMT
> Anybody notice that while debugging, excel (and some other apps) have a
> "hard time" opening?  Anybody know why this is?
[quoted text clipped - 4 lines]
>
> Rudy

It has to do w/ the DDE server getting blocked (DDE makes extensive use of
window messaging, and if the application you are debugging is at a breakpoint
(essentially blocked), then the DDE server will hang around waiting for that
app to respond before timing out and moving to the next app -- it is quite a
bit more involved, you can search old DevNet library articles on DDE, etc. for
further details).

To 'fix' the problem, you need to edit the file types that you want to have
more responsive so they don't use DDE during file open.

In your Excel example, you need to do the following:

Control Panel/Folder Options/File Types

Scroll down to XLS (or type in XLS and it will scroll down for you), click on
Advanced, Click on open action, edit, and then clear the Use DDE checkbox.

This should solve your 'problem', however you need to be aware that it may
cause some unintended side-effects (i.e. multiple instances of Excel running
instead of multiple worksheets opening in a single instance of Excel).  Make a
note of the DDE settings if you want to restore to the previous configuration.

If it works for you, you will have to make the above change to all of the file
types that you want affected.
Rudy Ray Moore - 12 May 2004 19:15 GMT
Thanks so much Julie!

> > Anybody notice that while debugging, excel (and some other apps) have a
> > "hard time" opening?  Anybody know why this is?
[quoted text clipped - 29 lines]
> If it works for you, you will have to make the above change to all of the file
> types that you want affected.

Rate this thread:







Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.