From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, 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: 

labview excel with activex

Solved!
Go to solution

Oh i am a bit stupid there is indeed a Sheetname entry, what should i put on it ? the name of the file (ok2 in my example) ? 

using labview 2014, beginer on labview
0 Kudos
Message 11 of 29
(3,360 Views)

i think i managed to resolve this probleme by putting "Feuil1" (french version) which is equivalent to "Sheet1", but now i have an other probleme:  error -2146827284 s'est produite à : Unknown System Error dans Untitled 1.vi

using labview 2014, beginer on labview
0 Kudos
Message 12 of 29
(3,353 Views)

Hi Louis,

 

did you debug this VI? Where eactly does the error occur?

Which ActiveX property throws the error?

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 13 of 29
(3,344 Views)

in the node "application" does the error occur

 

using labview 2014, beginer on labview
0 Kudos
Message 14 of 29
(3,341 Views)

Hi Louis,

 

is Excel installed on your computer?

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 15 of 29
(3,337 Views)

yes it is, maybe something strange, before i was looking on the internet to find a complete VI i tried to use activex to creat all on my own and excel application doesn't appear when i create an activex objet and right clic to insert activex component, excel is not available

using labview 2014, beginer on labview
0 Kudos
Message 16 of 29
(3,349 Views)

think it is in the last close reference that the error occur

using labview 2014, beginer on labview
0 Kudos
Message 17 of 29
(3,332 Views)

@louis293 wrote:

think it is in the last close reference that the error occur


Hi louis,

 

How long you are Using LabVIEW, If you are very new please go through basics of LabVIEW.

I have attached Snippet for your understanding and not to provide you the end solution.

Try to select the Activex ref by browsing and find the MS Excel Ref.

----------------------------------------------------------------------------------------------------------------
Palanivel Thiruvenkadam | பழனிவேல் திருவெங்கடம்
LabVIEW™ Champion |Certified LabVIEW™ Architect |Certified TestStand Developer

Kidlin's Law -If you can write the problem down clearly then the matter is half solved.
-----------------------------------------------------------------------------------------------------------------
0 Kudos
Message 18 of 29
(3,317 Views)

thanks, i have the basis of labview i am using it since two weeks, but not good enought to understand  all of  the vi to write to excel

using labview 2014, beginer on labview
0 Kudos
Message 19 of 29
(3,313 Views)

Try to analyze the code Step by step (use Highlight Execution) and Understand whats happening.

----------------------------------------------------------------------------------------------------------------
Palanivel Thiruvenkadam | பழனிவேல் திருவெங்கடம்
LabVIEW™ Champion |Certified LabVIEW™ Architect |Certified TestStand Developer

Kidlin's Law -If you can write the problem down clearly then the matter is half solved.
-----------------------------------------------------------------------------------------------------------------
0 Kudos
Message 20 of 29
(3,314 Views)