Writing to specific cells of existing Excel file and saving as a new file using LV 8.6

[Aarontan90]

Hi all,

I am new to LV and am currently tasked to create a program that can open an existing excel file, input data in the program that will be written to a specific cell in the excel file and then saving the current edited file as a new file.

I have browsed through all the forums but I am unable to view the examples sent in them as I am using LV 8.6 which is why I am still having trouble visualizing how to create a program like this. Can anyone help me and mentor me how to write this program in this version of LV? I do not have a microsoft office toolkit hence another approach could be preferred. Thank you.

Aaron

[KateB · Accepted solution]

[KateB]

Don't forget to save workbook as well.

[Aarontan90]

Thank you for helping me on this. However I do not really understand how does ActiveEx work. I have created a Vi according to the picture that you provided but there was some error in running the file.

Below is my own VI that I am trying to create. It consists of multiple string inputs which I am trying to input each into an existing file. I have created a separate txt file which has the cell numbers. I am trying to allocate each string into each respective cell in an existing file. I am currently having the problem of doing this "allocation" of each string as I do not have the microsoft office tool kit. Is there any other way for me to do so?

Also, I would like to save the newly created file as a new file with the name as seen in my VI. How would I be able to do it?

Please help me as I am stuck here but do not know how to continue

[aputman]

The attachment posted is a snippet.  It's a png file with embedded Labview code.  Drag and drop this image to your desktop and then drag it into the block diagram of a VI.  It will re-create the code for you.  This one is Labview 8.6.