Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WScript.Shell
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
WScript.Shell
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. | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
WScript.Shell
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. | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
WScript.Shell
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. | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WScript.Echo... VBA Reference? | Excel Programming | |||
User Name via 1. API, 2. Enviornment, 3. WScript.Network | Excel Programming | |||
using WScript.CreateObject("Wscript.Shell | Excel Programming | |||
Office 2003 not able to run wscript?? | Excel Programming | |||
WScript object not found (???) | Excel Programming |