alchoi01

Thanks for the help guys. I know about opening text files via excel. My goal is to "dummy proof" this process and have LabView automate as much of the data transfer to excel as possible instead of relying on our rather inept operators.

So far the LabView program creates an output text file. I need to then transfer that text file into a specific sheet of an existing excel workbook either directly or by renaming the text file and running an existing macro through excel.

I'll try playing with the ActiveX and GOOP functions. I have never used ActiveX, though, so any tips will be greatly appreciated.

Thanks for the help. I will try using ActiveX for the first time. In the mean time, our current process requries chyanging the name of the output text file, then running an excel macro to import the data. I know how to run the excel macro via LabView, but is there a function to change a file name? It is a .txt file.

I have a created an output text file of my data using Labview. I need to be able to export this file into a specific sheet of my excel template. I need to write the text file first because it is not simply an array, but a combination of several strings and arrays. This is how the program was originally written, and i do not know how to change this. I am looking for an easy way to export the existing output file (.txt) into my excel workbook after the initial creation of the text file.