Using the add-on to LabVIEW, Report Generation, I notice that the Append Text...vi is very slow to put information into an Excel sheet. I've tracked this down to the macro that is run at the end of the append VI that appears to convert the appended cells in some (important) way. Thus, the data is appended very quickly, but the macro takes quite a while. Is there some way to improve this? I've seen other applications write Excel sheets almost instanteously, so my application looks rather sad when compared to these.
The macro is used to get Excel to recognize the proper format of the text (the text could be all numeric). If you are inserting alphanumeric text then you can delete the three subVI's related to this macro. If you do this please rename the VI so you don't overwrite the original version.