message box transient -sub by Chip Perason
thanks. there is no other reference . is the problem with windows98 or excel
version excel 2000.
the file wshom.ocx is in forlder c:\windows\system(not in system32).
Gareth wrote in message
...
Are you sure you have the right OCX referenced?
On my machine (XP, XL2003) it is called (exactly) "Windows Script Host
Object Model".
c:\windows\system32\wshom.ocx
Maybe it doesn't work on 98SE? Sorry I can't be of more help.
Gareth
R.VENKATARAMAN wrote:
In one of my serches in googles group I found pearson's sub on having a
transient message box
quote
Dim SH As IWshRuntimeLibrary.WshShell
Dim Res As Long
Set SH = New IWshRuntimeLibrary.WshShell
Res = SH.Popup(Text:="Click Me", secondstowait:=5, _
Title:="Hello, World", Type:=vbOKOnly)
unquote
as suggested i have referenced in vbeditor tools references
<windows scripting host object model(ver 1.0)
and then run the above sub
But I get an error message and the sub stops at the line
<Dim SH As IWshRuntimeLibrary.WshShell
the error mesage is
<user defined type not defind
where I am doing the mistake
mine excel 2000
windows 98SE
request help
thanks regards.
|