10-01-2009 02:35 PM
Is there a way to know possible error (or exception) thrown by Excel while editing using Active X control in LabVIEW environment ?
For illustration:
1] Created a new blank excel workbook which by default opens with three worksheet (Sheet1, Sheet2 & Sheet3).
2] Delete two worksheet and rename the last one as the coversheet and keep adding sheet as per requirement.
Problem:
Here in Step2, after deleting Sheet1, when the program tries to delete Sheet2, the Excel Application throws a popup - "Not enough system resource to display" and waits for user to acknowledge the popup, whereas in LabVIEW the Active X control returns an error and proceeds further program execution.
This part of code is in a for loop with delay time set as 150ms.
This is just one scenario (one popup), but to make a fail-safe software, I need to know about possible popups that can come and when. So where can I find this information. Guess, am not the only person in whole world who has faced this situation, so if anyone out there be kind enough to share his/her experience, would really appreciate it.
Thanks and Regards,
Tirthankar De
10-01-2009 03:20 PM
This is what we did for this situation. If you look at the picture where it is circuled is how you show errors that Excel will throw.
10-02-2009 01:15 AM
Excel with LabVIEW resources board:
http://forums.ni.com/ni/board/message?board.id=BreakPoint&message.id=2391#M2391
MS Excel developer centre:
http://msdn.microsoft.com/en-us/office/aa905411.aspx
You can find many useful reference docs about Activex commands for Excel - something not included with LV documentation.