View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default message box transient -sub by Chip Perason

Hi Norman,

I was anticipating coming back to this thread needing to start my reply
with -Doh...! So I'm rather glad you report similar.

Gareth's observations are interesting, but like you I don't have enough
"sulking ability" to see for myself!

No doubt there's some simple explanation, but whatever it is in the light of
our experiences it suggests the method cannot be distributed reliably, a
shame.

Dave - re your suggestion in another part of this thread:
Before posting my first reply I had tried Late Binding but got the same non
result, ie no error but the popup msgbox wouldn't close without me clicking.
First time forgot to include a button, eventually had to Ctrl-Alt-Del.

Regards,
Peter T

"Norman Jones" wrote in message
...
Hi Gareth,

Out of curiosity, maybe it's the same for you?


I'm afraid not.

My attention span collapsed after 90 secs and I manually closed.

Perhaps, however, I do not have your prodigious sulking ability!

---
Regards,
Norman



"Gareth" wrote in message
...
Hey Norman,

I thought that originally - but then (I don't know why) I sulked and
refused to click it away and it disappeared of its own volition after
about 40". Out of curiosity, maybe it's the same for you?

Indeed, I decided to change the SecondsToWait parameter and the results
were as follows:

Sec nn:ss
1 - 00:03
2 - 02:08
3 - 00:27
3 - 00:07
4 - 00:27
5 - 00:19

Clearly inconsistent - makes this somewhat unusable.

Thanks,
Gareth

Norman Jones wrote:
Hi Peter,


Unlike you I don't get an error, but it just doesn't work as expected


My experience replicates yours, albeit with a xl2k/winXp configuration:
the message box appears (without error) but requires manual dismissal.

---
Regards,
Norman



"Peter T" <peter_t@discussions wrote in message
...

I should have made clear there's quite a difference in the way things
don't
work for us. You said -
"
But I get an error message and the sub stops at the line
<Dim SH As IWshRuntimeLibrary.WshShell
"
Unlike you I don't get an error, but it just doesn't work as expected.

Regards,
Peter T