vba createobject( wscript.shell ).specialfolders

Im attempting to use Wscript.Shell through Word 2002 VBA to access a shortcuts TargetPath.Dim WshShell Set WshShell Wscript.CreateObject("Wscript.Shell") MsgBox "Your desktop is " WshShell. SpecialFolders("Desktop"). Set objShell WScript.CreateObject("WScript.Shell"). All users Desktop.usersDesktop objShell.SpecialFolders("Desktop"). Where to create the new shorcut. Function m() As String Set WshShell CreateObject("WScript.Shell") m WshShell. SpecialFolders("Desktop") End Function.Convert Your Access Database Into An Exe. MS Access VBA Open a File. DoCmd.OutputTo in xlsx (Excel 2007) Format. How to Compile VBA If I run the .jar manually with double click all is fine, but if I run the file with this VBA code: Private Sub Comando8Click() Set WshShell CreateObject("WScript. Shell") strDocuments WshShell.SpecialFolders("MyDocuments") FileName "HotelFiller Macro Security Settings VBA Project Object Module.

Error Trapping Mode VB Editor. Kill Process VBS.Set wshShell WScript.CreateObject("WScript.Shell"). Help with VBA syntax. This comment was posted to reddit on May 23, 2015 at 12:35 pm and wasCreate the Shell and FileSystem objects Set Wsh CreateObject("WScript. Shell") Set FsoConstruct the string that contains the new folder on the user desktop TestPath Wsh. SpecialFolders Returns a SpecialFolders object (a collection of special folders).script language"VBScript">.