10-26-2018 03:59 AM
I'm trying to execute the code and the same error occurred:
Untitled_1.vi: The error with the highlight execution appears in Application property node. Visible property.
ExcelSaveAsTxt.vi: The error with the highlight execution appears in Application Invoke Node Open.
Can anybody help me?????
10-26-2018 04:06 AM
10-26-2018 04:18 AM
which errors occured?
Error -2146827864 occurred at Unknown System Error in ExcelSaveAsTxT__.vi
This error code is undefined. Undefined errors might occur for a number of reasons. For example, no one has provided a description for the code, or you might have wired a number that is not an error code to the error code input.
Additionally, undefined error codes might occur because the error relates to a third-party object, such as the operating system or ActiveX. For these third-party errors, you might be able to obtain a description of the error by searching the Web for the error code (-2146827864) or for its hexadecimal representation (0x800A01A8).
Which input parameters do you use?
FileFormat Control: xlUnicodeText (42)
File In: Select the path of file
Is Excel installed on your computer?
Yes
Which version?
2016 Profesional Plus
10-26-2018 04:33 AM - edited 10-26-2018 04:36 AM
10-26-2018 04:36 AM
Thanks GerdW.
I'll try in other computer with Office2010 o Office2013.
Best regards,
Dirizabal
06-30-2020 04:12 AM
Hello!
Great help here, thanks!
I only need a small advice. I want to insert numeric values from LabVIEW into an excel template, which already has an "Autoformat" on a specific column to put in red values lower than a value (0.5, e.g.)
My problem is that when I open the LabVIEW file, I see the values were written as text.
Any idea of how to write them directly as numbers? Or programatically setting that range of cells to numbers after being written?
Thanks!
06-30-2020 04:14 AM
Never mind. I just tried something that I thought would work and it did. Change the 2D array in labview to numerical, and it will just work.
12-09-2022 01:41 AM
Hi!
I know that this topic is quite old, but it still something used today! So I'll take my chance! 🙂
I used the example of PalanivelThiruvenkadam, but I face an issue when calling the Range method (error -2146827284). I want to select a single cell and not a range. However, I already used this method in VBA and I know that it's possible to select a single cell (i.g. C8:C8).
Am I supposed to format the range an other way?
Thank you in advance for your precious help!
Julien
12-09-2022 04:12 AM - edited 12-09-2022 04:13 AM
Hi!
I know that this topic is quite old, but still something used today... So I take my chance!
I used the example of Palanivel and face an issue when calling the Range method: what I try to do is change the value of a single cell (merged cell). I tried to use only Cell1 param with the index of the cell, but this doesn't work (error -2146827284).
I used to work with VBA and I know that the range method can also be used for single cell (i.g C8:C8). However, this doesn't seems to work in LabVIEW.
Is there anything that I'm doing wrong?
Thank you in advance for your precious help!
Julien