Excel loses focus after desktop switches

Post a reply


This question is a means of preventing automated form submissions by spambots.
Smilies
:D :) :( :o :shock: :? :cool: :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :wink: :!: :?: :idea: :arrow: :| :mrgreen: (wave) :ok: (nod)
View more smilies

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Excel loses focus after desktop switches

Re: Excel loses focus after desktop switches

Post by Jim Davis » 04.11.2011 04:57:36

Thats a problem , this is a fairly complex app and it wont run at all without a live data feed .

I'll see if I can rig some simple version up that can be run at your end

Re: Excel loses focus after desktop switches

Post by Sebastian » 30.10.2011 16:44:22

:dex:,

Jim Davis wrote:Can't we find a way to trace the source of the problem.

send us the *.xls file if there's any chance of running the VBA without a data source?

Re: Excel loses focus after desktop switches

Post by Jim Davis » 27.10.2011 05:33:43

Still afflicted with this issue. Using 1.6 beta.

Can't we find a way to trace the source of the problem.

These userforms have embedded activex charts/spreadsheets, could that be part of the problem.

Re: Excel loses focus after desktop switches

Post by Jim Davis » 26.08.2011 06:01:59

Yes, I did that long ago.

Seems to be an issue where the window gets restored but stops responding to the mouse to regain focus. Everything else works, updating data, etc.

This happens every day, so its not some rare event. The move setting seems to fix windows that appear on the wrong desktop , but is not having an effect on this problem.


[Exe]
ObjectBar.exe=sticky
excel.exe=move
winamp.exe=move
stocks.exe=move

Re: Excel loses focus after desktop switches

Post by Sebastian » 25.08.2011 19:22:03

:dex:,

Jim Davis wrote:Kind of disappointing there doesnt seem to be any interest in fixing this.

not true.

Also see a very random loss of Quotetracker windows from time to time. The simply dont get restored, and reappear when QT is restarted.

try to set it to "=move" in your (my)wechsel.ini.

Re: Excel loses focus after desktop switches

Post by Jim Davis » 22.08.2011 18:51:12

Kind of disappointing there doesnt seem to be any interest in fixing this.

Also see a very random loss of Quotetracker windows from time to time. The simply dont get restored, and reappear when QT is restarted.

Re: Excel loses focus after desktop switches

Post by Jim Davis » 11.08.2011 05:54:11

I suspect it might have something to do with high cpu activity. During the day Im getting realtime market data and processing it. This problem seems to be related to switching desktops while excel (and /or the other apps) are quite busy.

Does this sound possible, and is there something that can be done?

Re: Excel loses focus after desktop switches

Post by Jim Davis » 09.08.2011 18:42:23

Still a problem, and a very annoying one. I have to use the windows menu to 'close' the Excel app.

No other app has this problem of focus. And its quite random, but happens often.

Re: Excel loses focus after desktop switches

Post by Jim Davis » 22.06.2011 19:26:54

Well, this is the only excel app I run daily. I run some other apps that use forms that do not have the problem.

It's very random. Can survive 500 desktop switches, and sometimes locks up after only a few.

I can't really debug this as there's nothing to see. Just wont go active when clicked, but still functions perfectly (displaying data)

There was another user that claimed to have the same issue.

Re: Excel loses focus after desktop switches

Post by Patrick » 21.06.2011 17:32:47

Have you tested whether the problem occurs with every userform or only with your app in particular?

Jim Davis wrote:Is there something about userforms that are 'sensitive' to desktop switches?

Unlikely. They are actually very similar to the VB6 forms used by Dexpot itself.

Re: Excel loses focus after desktop switches

Post by Jim Davis » 16.06.2011 05:45:01

Still having this annoying problem.

Is there no way to figure out why this is happening?

Happens every day, though my Excel app has been running all day today and the userforms are still selectable. Unusual actually.

Is there something about userforms that are 'sensitive' to desktop switches?

Re: Excel loses focus after desktop switches

Post by Patrick » 28.12.2010 13:53:55

Please describe the problem you are experiencing.

Re: Excel loses focus after desktop switches

Post by mikeunderwood » 27.12.2010 22:28:56

Patrick wrote:
Jim Davis wrote:What would cause the Userform windows to randomly lose the ability to be 'selected' by the mouse? They continue to display correctly, and show only on the desktop they are assigned to . Just can't be clicked and brought into focus. I get a system 'bell' sound when clicking on them.

Does your app use message boxes or other modal windows that could somehow be lost somewhere?


I have the same problem, if there are any log files that would help let me know.

Re: Excel loses focus after desktop switches

Post by Patrick » 21.11.2010 21:05:53

Jim Davis wrote:What would cause the Userform windows to randomly lose the ability to be 'selected' by the mouse? They continue to display correctly, and show only on the desktop they are assigned to . Just can't be clicked and brought into focus. I get a system 'bell' sound when clicking on them.

Does your app use message boxes or other modal windows that could somehow be lost somewhere?

Re: Excel loses focus after desktop switches

Post by Jim Davis » 16.11.2010 04:59:06

Yes, I made sure the overwritten file was updated to include the .
excel.exe=move

It gets a little weird under Win 7 X64, as the actual ini file that's used is located in the "VirtualStore" directory. I created a mywechsel.ini as you suggested.

Before doing anything today, I ran the program all day, many desktop switches as usual, and didn't have the problem. It's very random.

Re: Excel loses focus after desktop switches

Post by CircleDock » 12.11.2010 19:41:36

Jim Davis wrote:Yes, I added that line to the ini file long ago.

What would cause the Userform windows to randomly lose the ability to be 'selected' by the mouse? They continue to display correctly, and show only on the desktop they are assigned to . Just can't be clicked and brought into focus. I get a system 'bell' sound when clicking on them.


Any chance that you have updated Dexpot since adding that entry? The reason being that "wechsel.ini" is overwritten whenever you update the program. To ensure it survives updates, place the entry (same syntax exactly) in a new file, "mywechsel.ini".



Mark

Re: Excel loses focus after desktop switches

Post by Jim Davis » 12.11.2010 06:12:57

Yes, I added that line to the ini file long ago.

What would cause the Userform windows to randomly lose the ability to be 'selected' by the mouse? They continue to display correctly, and show only on the desktop they are assigned to . Just can't be clicked and brought into focus. I get a system 'bell' sound when clicking on them.

Re: Excel loses focus after desktop switches

Post by Patrick » 10.11.2010 23:05:45

Did you try the suggestion from my last post?

Re: Excel loses focus after desktop switches

Post by Jim Davis » 06.11.2010 06:26:17

Still have this annoying issue. Very few problems with Dexpot (running the latest build 1394) but this one won't go away. Happens every day . Since it only seems to happen randomly after 'x' numver of desktop switches, I assume there's something that can be repaired.

I understand you probably can't duplicate this on your machine, but is there any chance of fixing this. A userform should not lose the ability to be activated by the mouse. In order to close the program , I have to call up the Dexpot window manager and tell it to close the app, which does work as it should.

Re: Excel loses focus after desktop switches

Post by Patrick » 29.07.2010 17:27:27

Not forgotten, but not reproducible either. Could it have something to do with your VBA app?

Maybe try adding the following to the Exe section of the wechsel.ini:

Code: Select all

excel.exe=move

Top