LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Labview to push a button in excel

Solved!
Go to solution

Dear all,

 

I have developed a Labview VI but now I need the VI to activate an excel add-in at a certain moment. The add-in allows to start a measurement with a device which I was not able to control by labview (Lightmeter SEKONIC C-7000), and the measurement should start at a well defined moment. So what I need to do is to push a button into excel to start the measurement, while the VI is running.


Is it possible to interact into excel using labview? After the VI has done some initialization, I would need that it goes into excel and push only one button to start the measurement.....

 

THanks to all for the support....

0 Kudos
Message 1 of 14
(1,323 Views)

Its quite possible to Read from/write into excel using LabVEW, what do you mean by push button in excel or do you mean the excel interaction to be happened after push button is being triggered?

Palanivel Thiruvenkadam,
Certified (LabVIEW || TestStand) Developer
0 Kudos
Message 2 of 14
(1,317 Views)

Thanks for your quick answer!

 

In the excel menu, I have an add-on which allows to control the measurement device SEKONIC C-7000.

 

 

What I need to do is to periodically push the button "measurement start" - please see the image attached... Is this possible?

0 Kudos
Message 3 of 14
(1,306 Views)

can you share the excel file instead of image, so that we can try ourself .

and i have never tried this earlier but i think it sholud be possible by invoking excel application.

Palanivel Thiruvenkadam,
Certified (LabVIEW || TestStand) Developer
0 Kudos
Message 4 of 14
(1,279 Views)

The excel file is a generic, empty excel sheet.... It will be then filled up with the measurement results...

0 Kudos
Message 5 of 14
(1,276 Views)

The Reason i asked to share your excel is, LabVIEW can able to invoke the inbuilt excel functions, but you have added Measurment start and Measurement abort so need to confirm whether the customized buttons can be accessed via LabVIEW

Palanivel Thiruvenkadam,
Certified (LabVIEW || TestStand) Developer
0 Kudos
Message 6 of 14
(1,269 Views)

Here is one generic excel file filled up with some measurement....

However I am afraid that, if you do not have the special add-on for excel to interact with the SEKONIC instrument, you won't see the "measurement start" button

0 Kudos
Message 7 of 14
(1,265 Views)

You are correct -- I do not see Measurement Start.

 

However, you might be able to "have your cake and eat it, too".  Action Buttons in Excel execute a linked Macro when they are pushed.  This suggests that your Workbook (showing the button) has VBA code associated with it that runs a specific named Macro when the button is pushed.  If you examine your Workbook and determine the Macro, you should be able to get LabVIEW to execute it (the easiest way being using the Excel Run Macro function found in the Advanced sub-Palette of the Report Generation Toolkit).

 

Bob Schor

0 Kudos
Message 8 of 14
(1,254 Views)

It looks like a cake too difficult to prepare!!!
I am not able to determine the name of the macro associated with the push button. Any suggestion how to do that?

0 Kudos
Message 9 of 14
(1,206 Views)

Not experienced with Add-ons in Excel but try this.

 

In Excel under the Developer tab, enter design mode then look at the properties for the button.

Also under Devloper see if the Add-In functions can expose anything of use.

 

Edit- Forgot to mention that the code or macro name may be visible via the Visual Basic or Macros selecyions under the Developer tab.

 

-AK2DM

 

 

~~~~~~~~~~~~~~~~~~~~~~~~~~
"It’s the questions that drive us.”
~~~~~~~~~~~~~~~~~~~~~~~~~~
0 Kudos
Message 10 of 14
(1,196 Views)