How does one declare an array in VBScript?

Question

I used this in Excel and it works fine.

dim varScreen (0 to 2) as string
varScreen(0) = "sample 1"
varScreen(1) = "sample 2"
varScreen(2) = "sample 3"

I am trying to translate this array to VBScript but I keep getting this error:

Line: 14
Error: Expected ')'

I have tried various options, removed as string, dim varScreen as array but I still get the error.

What is the proper syntax?

There is a space between varScreen and (0 to 2). There should not be. — David Zemens
– David Zemens, Commented Mar 28, 2015 at 18:00

Helen · Accepted Answer · 2015-03-30 09:22:12Z

15

You can also create arrays dynamically using the Array function. Sometimes this is more convenient than assigning array elements separately.

Dim arr
arr = Array("sample 1", "sample2", "sample 3")

answered Mar 30, 2015 at 9:22

Helen

99.8k18 gold badges280 silver badges352 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Cellcon Over a year ago

Or, if you want to have it all in a single line, use Dim arr : arr = Array("sample 1", "sample2", "sample 3").

Ekkehard.Horner · Accepted Answer · 2015-03-28 18:10:54Z

11

VBScript's (variables and) arrays can't be typed, so no "as Whatever". VBscript's arrays are zero-based, so no "(x To y)" but only "(z)" where z is the last index (not the size) of the array. In code:

>> Dim varScreen(2)
>> varScreen(0) = "sample 1"
>> varScreen(1) = "sample 2"
>> varScreen(2) = "sample 3"
>> WScript.Echo Join(varScreen, "|")
>>
sample 1|sample 2|sample 3
>>

answered Mar 28, 2015 at 18:10

Ekkehard.Horner

38.8k2 gold badges50 silver badges101 bronze badges

4 Comments

Stevoisiak Over a year ago

What are the >> marks for? They make the code a bit harder to read.

Ekkehard.Horner Over a year ago

>> is the prompt of my REPL.

Passer-by Over a year ago

I encountered similar problem by writing (1 To n), which works fine in vba, I just wanted my array to have base 1, so how can I realize base 1 not from 0? Thanks!

Ekkehard.Horner Over a year ago

You can't have native base 1 arrays in VBScript. Just adapt your access code.

Collectives™ on Stack Overflow

How does one declare an array in VBScript?

2 Answers 2

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related