I don't want to be able to access the VBS array Batch1() directly.
In this example I was able to assign the results of the VBS expression UBound(Batch1) to the VBP TOTAL_BATCH1. This works.
Application.Macros(vbldTemporary).Add "TOTAL_BATCH1", UBound(Batch1)
In VBS I can do something like this:
dim Array1(3)
Array1(0) = "Blah"
Array1(1) = "Foo"
Array1(2) = "Fubar"
ABC123 = Array1
MsgBox ABC123(2)
This code will give me a msgbox with "Fubar" in it. I am saying, this array in VBS is equal to this array in VBS.
I was able to pass an VBS variable to a VBP variable. I want to be able to pass my VBS array to VBP so it can be used.
The PDF documentation isn't of much help here.
Last edited by gdanko; 05-27-2003 at 05:37 PM.
|