[gdanko]

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.