From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Handling Popups in Excel with ActiveX

Solved!
Go to solution

I'm having a problem similar to the problem referenced in this post:

 

https://forums.ni.com/t5/LabVIEW/Handling-popups-of-Excel-while-editing-it-via-Active-X-Control/td-p...

 

The difference being...

 

My company has an Excel "database" that stores all of our product information. When starting my application I read from this database using ActiveX. Recently this Excel sheet was updated to include new capabilities by someone else within my company.

 

Now, when opening this particular worksheet, I get this message:

 

excel.PNG

 

It doesn't come to the front of the screen, and unless the user realizes that it is coming the LabVIEW program seems to hangup, causing the user to close the LabVIEW program, because they don't realize that LabVIEW is waiting on Excel, which is waiting on the user to make a selection on this popup.

 

In the post I referenced above, they get around this by using a Property Node with the "Display Alerts"  property set to false. This works for hiding errors but doesn't seem to work for this instance. 

 

Is there a way, through ActiveX, to "click" the "Don't Update" button without the user having to do this.

 

OR

 

Worst case scenario, is there a way to bring this popup to the front to alert the user that Excel needs input?

 

Thanks

0 Kudos
Message 1 of 2
(2,534 Views)
Solution
Accepted by topic author bshover

If anyone stumbles upon this page looking for a solution, here is how I ended up solving the issue:

 

http://support.microsoft.com/KB/826921

0 Kudos
Message 2 of 2
(2,475 Views)