LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Handling popups of Excel while editing it via Active X Control

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 

0 Kudos
Message 1 of 3
(3,044 Views)

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.

 

Delete Workbook Pages.png

Tim
GHSP
Message 2 of 3
(3,032 Views)

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.

Message 3 of 3
(3,016 Views)