Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI
1 rating:
 1 out of 5     Rate this Document

General Suggestions When Encountering Errors Using Excel Macros 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'm writing an Excel macro that uses Measure functions. When I try to run my macro I get any one of a number of errors back from Excel. How can I fix these errors?

Solution:
The first thing you should do is make sure that the Measure functions are working properly outside of the macro environment. You can do this by trying to run a simple task from the DAQ, GPIB, or Serial pull-down menu. If you run into problems when simply running the tasks, please address these issues before continuing.

Assuming the tasks run successfully, this means that most likely there is an invalid call in the Excel macro. If the macro ran fine in a previous version of Excel, perhaps your macro has a legacy function in it that is no longer supported by the version of Excel you are using.

Measure 2.0 is fully backwards compatible: any functionality programmed in a previous version of Measure will work properly in Measure 2.0.

Most importantly you should read the Help file that comes with Measure 2.0 and be familiar with Visual Basic for Applications (VBA) and macro writing to aid your troubleshooting.

Note that National Instruments does not provide support for writing Excel Macros or VBA code. We do, however, have several examples available on our NI Developer's Zone that might help you get started with programming your own Measure applications in Microsoft Excel using macros or VBA. These examples are available at the link below. For resources on these subjects, please check out the Microsoft Developer's Network.



Related Links:
Measure Support
NI Developer Zone: Measure Example Programs
KnowledgeBase 0KMBQE9A: Resources for Writing Macros in Excel for Measure

Attachments:





Report Date: 12/06/2000
Last Updated: 02/12/2009
Document ID: 2459I6DM

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