Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI
This Document is not yet Rated  Rate this Document

"Out of Resource" Error Running an Excel Macro With Measure

Primary Software: Other NI Software>>Measure
Primary Software Version: 2.0
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem: I have a large Excel macro that calls, among many other things, Measure functions. After running for a period of time, Excel will crash with an "Out of Resource" or "Out of Memory" error. Is Measure causing this error?

Solution: Since all Measure I/O functions are high-level function calls that always open and close their references to the driver in the same call, Measure will never leave a reference to the hardware open, which is what usually causes this problem. Most likely you are doing some low-level device calls in your macro, and these are resulting in the crash. Make sure you can run the Measure functions on their own without problems (by using the pull-down menus directly). Then, remove the Measure functions from your macro to see if the crash still occurs. Make sure to use a resource monitor of some kind (like the Diagnostics window in Windows NT or the Resource Monitor in Windows 98) to monitor the memory and heap space usage on your computer while the program runs. If none of these suggestions help, try your program on another computer - there might be something wrong with your particular computer that is causing this crash.



Related Links: Measure Support


Attachments:





Report Date: 12/06/2000
Last Updated: 12/02/2004
Document ID: 245D8ODM

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
  1 2 3 4 5
Please Contact NI for all product and support inquiries.submit