View Single Post
 
Old 11-08-2022, 01:27 PM
BrianHoard BrianHoard is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Jul 2022
Location: Haymarket, VA USA
Posts: 85
BrianHoard is on a distinguished road
Default Using .Net arrays in VBA crashes Word

We have written several scripts using .Net arrays (forgive me if that's the wrong name, that's what we have been calling them). We are now seeing that Word crashes immediately if certain users try to run these scripts. No warning, no locking up or spinning cursor, Word just closes.

We have found the common problem is that any script where we have used .Net arrays are the culprit. We are using them like this...

Code:
' .net arrays
Dim enDupes_LL as Object

' Create the empty array
Set enDupes_LL = CreateObject("System.Collections.ArrayList")

' We append to this array like this...
enDupes_LL.Add Array(int_master, eNumber, enRefText)

' We can get the size of the array using...
If enDupes_LL.Count == 0  Then
Please let me know your advice how we can either solve the problem to allow these arrays to work on all users computers, or a better approach instead of using them.
I'm guessing that it has to do with what version of .Net a user has installed. But still troubleshooting that.

I recall originally looking into using VBA arrays, but could not see how I would append to them, or get their size, like with using .Count

Thank you for any help.
Reply With Quote