Thread: WScript.Shell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
dani dani is offline
external usenet poster
 
Posts: 13
Default WScript.Shell


I also think so.

Thank you.

"John Coleman" wrote:

I think that library will work:

Sub test()
Dim wsh As WshShell
Set wsh = New WshShell
wsh.Popup "hi"
Set wsh = Nothing
End Sub

-John Coleman

Dani wrote:
Thank you for replying.

I've already tried that library. But my code still doesn't compile:

Dim wsh As WScript.Shell
Set wsh = new WScript.Shell


"Jim Rech" wrote:

Try: "Windows Script Host Object Model"

c:\windows\system32\wshom.ocx

--
Jim
"Dani" wrote in message
...
| Hi,
|
| My question is simple: I have to use the WScript.Shell object from VBA
| (Excel 2000), but i want to use early-binding (instead of
| late-binding-- CreateObject("WScript.Shell")).
|
| I'm unable to find out what reference I must to set in the VBA editor
| in order to use that object.
|
| Thank you beforehand.
|