Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Getting compile error: out of memory in VBA How do I fix this?

I am making a project in Microsoft Excel using a Macro. I call external
program(lp_solve) functions in my code. I am getting several errors when I
run my program. The first is "Microsoft Excel has encountered some problems
and needs to shut down." The second says something about available
resources. And finally the third is a Microsoft Visual Basic Compile Error:
Out of memory.

Does anyone know how I can check memory usage, gain memory back, or why I am
getting these messages?

Thanks for your help.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Getting compile error: out of memory in VBA How do I fix this?

It would help to see your code that produces the error messages.

"jhaukap" wrote:

I am making a project in Microsoft Excel using a Macro. I call external
program(lp_solve) functions in my code. I am getting several errors when I
run my program. The first is "Microsoft Excel has encountered some problems
and needs to shut down." The second says something about available
resources. And finally the third is a Microsoft Visual Basic Compile Error:
Out of memory.

Does anyone know how I can check memory usage, gain memory back, or why I am
getting these messages?

Thanks for your help.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBAProject name compile error, not defined at compile time Matthew Dodds Excel Programming 1 December 13th 05 07:17 PM
error message: compile error, argument not optional Pierre via OfficeKB.com Excel Programming 3 September 5th 05 03:45 PM
compile error: out of memory bforster1[_4_] Excel Programming 1 July 21st 04 03:47 PM
VBA Excel - Compile Error: Out of Memory Linda G Excel Programming 1 June 23rd 04 03:07 AM


All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"