<div>
Try this inside your loop:<br />
<br />
ReDim Preaserve arrayClientOrderID(i)<br />
arrayClientOrderID(i)= ClientOrderID
</div>


Try this inside your loop:

ReDim Preaserve arrayClientOrderID(i)
arrayClientOrderID(i)= ClientOrderID

<div>
Reeds, please accept an answer to close this question.<br />
<br />
Thanks,<br />
<br />
Rob.
</div>


Reeds, please accept an answer to close this question.

Thanks,

Rob.

<div>
<div class="content wysiwyg-content">
I have a for loop in which I am reading from an excel file. I want to put some values in an array. I tried doing:<br />
<br />
i = 0<br />
Dim arrayClientOrderID()<br />
arrayClientOrderID(i)= ClientOrderID<br />
i = i + 1<br />
<br />
The above gives me an error. I don't know the size of the array because I am looping through each line of the excel file and taking the values for Client orderID. How can I assign and initialize dynamic arrays.
</div>
</div>


I have a for loop in which I am reading from an excel file. I want to put some values in an array. I tried doing:

i = 0
Dim arrayClientOrderID()
arrayClientOrderID(i)= ClientOrderID
i = i + 1

The above gives me an error. I don't know the size of the array because I am looping through each line of the excel file and taking the values for Client orderID. How can I assign and initialize dynamic arrays.

How to declare and initialise dynamic arrays in VB script?

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.