Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 130
  • Last Modified:

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.
0
mbarron
Asked:
mbarron
1 Solution
 
fguerreiro_inixCommented:
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now