Visual Basic scripting dynamic array

by

You can’t re-dimension a fixed-size array (Dim vprglist(10)). If you want a dynamic array, define a “normal” variable and assign an empty array to it:

Dim vprglist : vprglist = Array()

or define it directly with ReDim:

ReDim vprglist(-1)

Then you can re-dimension the array like this:

If vprogram.LastRunTime = "" Then
  ReDim Preserve vprglist(UBound(vprglist)+1)
  vprglist(UBound(vprglist)) = vprogram.FullName
  i = i + 1
End If

ReDim Preserve will copy all elements of the array into a new array, though, so it won’t perform too well in the large scale. If performance is an issue, you’d better use the System.Collections.ArrayList class instead:

Dim vprglist : Set vprglist = CreateObject("System.Collections.ArrayList")
...
If vprogram.LastRunTime = "" Then
  vprglist.Add vprogram.FullName
  i = i + 1
End If

More Related Contents:

  1. VBScript getting results from Shell
  2. In Powershell, what’s the best way to join two tables into one?
  3. How to delete items from a dictionary while iterating over it?
  4. Escaping Double Quotes in Batch Script
  5. Can Windows’ built-in ZIP compression be scripted?
  6. Scripting Language vs Programming Language [closed]
  7. Using sed, Insert a line above or below the pattern? [duplicate]
  8. Running a CMD or BAT in silent mode
  9. Stopping scripters from slamming your website
  10. What are the best ways to automate a GDB debugging session?
  11. How can I sum values in column based on the value in another column?
  12. Determine if current PowerShell Process is 32-bit or 64-bit?
  13. How to read from a text file using VBScript?
  14. How do you execute an arbitrary native command from a string?
  15. How to compile a linux shell script to be a standalone executable *binary* (i.e. not just e.g. chmod 755)?
  16. Creating a script for a Telnet session?
  17. gdb scripting: execute commands at selected breakpoint
  18. Best tool(s) for decompiling Lua bytecode? [closed]
  19. Move folder from one directory to another in batch script
  20. How do I parse command line arguments in Bash?
  21. “ls: not found” after running “read PATH”
  22. How to get a password from a shell script without echoing
  23. Getting current directory in VBScript
  24. HTTP GET in VBS
  25. Running command line silently with VbScript and getting output?
  26. What does `set -x` do?
  27. Setting a windows batch file variable to the day of the week
  28. Passing arguments by reference
  29. VBScript & Access MDB – 800A0E7A – “Provider cannot be found. It may not be properly installed”
  30. How do I make Perl scripts recognize command-line parameters in the Win32 cmd console?

Leave a Comment