Ok, it’s actually simple. Assuming that your macro is in a module,not in one of the sheets, you use: objExcel.Application.Run “test.xls!dog” ‘notice the format of ‘workbook name’!macro For a filename with spaces, encase the filename with quotes. If you’ve placed the macro under a sheet, say sheet1, just assume sheet1 owns the function, which it … Read more
The conditional ternary operator doesn’t exist out of the box, but it’s pretty easy to create your own version in VBScript: Function IIf(bClause, sTrue, sFalse) If CBool(bClause) Then IIf = sTrue Else IIf = sFalse End If End Function You can then use this, as per your example: lunchLocation = IIf(dayOfTheWeek = “Tuesday”, “Fuddruckers”, “Food … Read more
I’ve only ever seen CopyFile fail with a “permission denied” error in one of these 3 scenarios: An actual permission problem with either source or destination. Destination path is a folder, but does not have a trailing backslash. Source file is locked by an application.
VB is a full-fledged programming language which can be used to create compiled applications, while VBScript is a sub-set of VB and is a scripting language that can be used to run a set of commands, similar to an old-school DOS batch file. Generally, a scripting language can not be used to create a full-fledged … Read more
Why not use For Each? That way you don’t need to care what the LBound and UBound are. Dim x, y, z x = Array(1, 2, 3) For Each y In x z = DoSomethingWith(y) Next
Handling Errors A sort of an “older style” of error handling is available to us in VBScript, that does make use of On Error Resume Next. First we enable that (often at the top of a file; but you may use it in place of the first Err.Clear below for their combined effect), then before … Read more
Dim o Set o = CreateObject(“MSXML2.XMLHTTP”) o.open “GET”, “http://www.example.com”, False o.send ‘ o.responseText now holds the response as a string.
Run cscript.exe for full command args, I think cscript //X scriptfile.vbs MyArg1 MyArg2 will run the script in a debugger.
Note – jump to the UPDATE 2014-04-27 section at the bottom of this answer for the best solution. I used to think the answer was no. But then DosTips user Liviu discovered that the <SUB> character (Ctrl-Z, 0x1A, decimal 26) has bizare effects when embedded within a batch file. If functions somewhat like a line … Read more
Try: WScript.Quit n Where n is the ERRORLEVEL you want to return