Which version of Microsoft Scripting Runtime ?
(In a console window, type cscript //v)
Anyway, your folder name contains embedded space, so I'll try this:
Set sh = CreateObject("WScript.Shell")
sh.Run """X:\Purchasing\Unfilled Report"""
or
sh.Run Chr(34) & "X:\Purchasing\Unfilled Report" & Chr(34)
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
And this ?
Private Sub Command6_Click(SetSh As Variant)
Dim Sh As Object
Set Sh = CreateObject("WScript.Shell")
Sh.Run """X:\Purchasing\Unfilled Report"""
End Sub
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
The Expression on Click you enteredas the event property setting produced the following error,
Procedure declaration does not match description of event or procedure having the same name.
* the Expression may not result in the name of a macro, the name of a used-defined fuction, or [Event prodedure]
*there may have been a error evaluating the fuction, event or Macro.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.