Key Value Extraction Array

16 posts / 0 new
Last post
rachel.organist
Offline
Joined: 12/12/2019 - 12:21

Also- thanks so much for this tip on the array type! I was driving myself to madness getting the "Invalid procedure call or argument" error repeatedly when I KNEW I was passing a string array...

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57
Hi Rachel, are you still looking for help with your script or did you get it working?
rachel.organist
Offline
Joined: 12/12/2019 - 12:21

Still trying to figure out the "You must create at least one key value" error. Do you have any suggestions?

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57
The main problem is that array has to be a multidimensional array, your array is a single array. Also you can't redefine that type of array, you have to set it up at the beginning, so what usually do is define it at its maximum
dim summFieldArray(499,0) as variant
You would populate it with your array values so
summFieldArray(0,0) = "First Key"
summFieldArray(1,0) = "Second Key"
summFieldArray(2,0) = "Third Key"

and so on. Don't worry about the blanks, IDEA seems to ignore those.

Try this out and let me know how it goes.
rachel.organist
Offline
Joined: 12/12/2019 - 12:21

Brian- This worked! Thank you!

Pages