Hi, I need to update worksheets/plots with text files that are generated from another program. At present I am doing this by waiting for the file to be generated and then dragging it with the mouse into the worksheet and letting the filter do the rest.
It is possible to use a script that checks (e.g. every 10s) for a new file at a given location and, if it finds one, automatically updates the worksheet (and associated plots). The generated files always have the identical column / row structure