VBA and Excel 97 on NT4 out of space

I find I have encountered some sort of memory boundary.
When I run a VBA script ,I get the message- something close to
 "Instruction at addr. ref memory at ox0e18 could
not be read."
THis message dissappears if I reduce the size of
several arrays which I need.
Question: is there some way to increase Excel's
resources so that I can run a bigger
VBA script.
mbarronAsked:
Who is Participating?
 
fguerreiro_inixConnect With a Mentor Commented:
Make an activeX exe with your VB scrips and add the reference to it. An activeX exe runs in a separate space of memory.
0
 
mbarronAuthor Commented:
How do I access this ActiveX exe, which I assume I create in
VB. Do I then write a "shell" vba script which somehow
references this ActiveX exe, and then run the "shell"
vba script as before, but with the guts removed from
the VBA script? Please, you can be very brief. I just need
a pointer or two. Many thanks. Mark
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.